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.
