Button to compact & repair current database (1 Viewer)

darkmastergyz

Registered User.
Local time
Today, 00:03
Joined
May 7, 2006
Messages
85
Is there a way to add a button which would automatically compact and repair my current database? Thanks.
 

Moniker

VBA Pro
Local time
Today, 02:03
Joined
Dec 21, 2006
Messages
1,567
Note that a compact/repair closes all the open objects, so this will close the form it's on and it will not reopen it. In the code for your Compact/Repair button, just put this:

SendKeys ("%T D C")
 

Users who are viewing this thread

Top Bottom