Compact and Repair

Gootz11

Registered User.
Local time
Today, 13:22
Joined
Apr 5, 2002
Messages
47
is there a way to perform compact and repair by using a command button and not having to go through tools? please help!

Thanks

JG
 
It is possible to program a command button that will compact "another" database, however you can't program a command button to compact the current database because it is still open and will fail.

You can always create a shortcut to compact the database.

There are a couple of parts to creating the shortcut.

Shortcut Properties for Target.
"Location of MSACCESS.EXE" "Location of Database" /repair /compact

Example
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Program Files\Database\My DB.mdb" /repair /compact

You can also set the database to compact and repair on close using the options within Access
 

Users who are viewing this thread

Back
Top Bottom