S S Jackson Jan 30, 2004 #1 I want to put in a Public Function in my database that will automatically compact and repair a Access 97 database. TIA S. Jackson
I want to put in a Public Function in my database that will automatically compact and repair a Access 97 database. TIA S. Jackson
B Bob Finster Jan 30, 2004 #2 Got to the menu for Tools...Options....General Tab. Check the "Compact on Close Box" in the lower left.
Got to the menu for Tools...Options....General Tab. Check the "Compact on Close Box" in the lower left.
S S. Jackson Jan 31, 2004 #3 Thanks Bob, but I don't think that option is available in Access 97. S. Jackson
D Douglas J. Steele Jan 31, 2004 #4 It's not. Since it's not possible to compact an open database (other than by using SendKeys, which is definitely not advised), take a look at the free TSI SOON (Shut One, Open New) add-in Michka has at http://www.trigeminal.com/utility.asp?ItemID=8#8
It's not. Since it's not possible to compact an open database (other than by using SendKeys, which is definitely not advised), take a look at the free TSI SOON (Shut One, Open New) add-in Michka has at http://www.trigeminal.com/utility.asp?ItemID=8#8
