Automatically Compact and Repair MDE

[Guest]

We've got an application compiled into an MDE, and I'm wondering if there is
a good way to have the application Compact and Repair the DB each time the
user exits the app?

The database is not split between a FE / BE scenario.

-David

 

[Roger Carlson]

With Access 2000, there is a feature to automatically compact it on close.
HOWEVER, I DO NOT recommend it. Instead, you should program it yourself.
This way, you can create a backup in case something goes wrong during the
compact. On my website (www.rogersaccesslibrary.com), there is a small
Access database sample which illustrates this: "CompactDatabase.mdb"
--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L