Access 97 - Compact database ? - TechRepublic
General discussion
April 10, 2001 at 02:26 AM
mbutton

Access 97 – Compact database ?

by mbutton . Updated 25 years, 1 month ago

I have written some VBA code (in Access 97) that compacts a given database.
The format is :
dbengine.compact
I do not want to create another copy of the db, but compact it onto itself, but the source and destination files cannot be the same.
The TOOLS->DATABSE UTILITIES->COMPACT menu option works great, but I want to automate the process, pergaps on shut down of the db.

Can anyone give me some pointers on how to gain access to this menu option, via code? or some better way of compacting my DB ?

Many thanks, in Advance, for your help
Mark.

This discussion is locked

All Comments