compact mdb

  • Thread starter Thread starter 00ScarlettJohnson
  • Start date Start date
If you're asking how you can compact the currently open database in Access
97, you can't using either a macro or VBA code.

If you're asking how you can compact another database (such as compacting
the back-end database from the front-end database), you can use the
CompactDatabase method of the DBEngine object (look up "CompactDatabase
Method" in the Help file)
 
Without knowing what you're trying to do (I listed two possible scenarios),
it's pretty difficult for anyone to answer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compact DB on close 1
Compact DB on close 2
Compacting NOT deleteing db1.mdb 11
Access 2007 mdb Deletes Self on Compact 3
compact repair fails after creating db1.mdb and deleting original mdb 2
db1.mdb file created when database compacts 5
Compact an Access Applicaton by checking Compact on Close 2
Compile error: variable not defined, ported from VBscript 5

Back
Top