compact mdb

  • Thread starter 00ScarlettJohnson
  • Start date
0

00ScarlettJohnson

How can I make the task of compact mdb into a macro in Access 97? Thanks.
 
D

Douglas J. Steele

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)
 
D

Douglas J. Steele

Without knowing what you're trying to do (I listed two possible scenarios),
it's pretty difficult for anyone to answer.
 
Top