D darkmastergyz Registered User. Local time Today, 14:38 Joined May 7, 2006 Messages 85 Aug 9, 2007 #1 Is there a way to add a button which would automatically compact and repair my current database? Thanks.
Is there a way to add a button which would automatically compact and repair my current database? Thanks.
M Moniker VBA Pro Local time Today, 16:38 Joined Dec 21, 2006 Messages 1,567 Aug 10, 2007 #2 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")
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")