A adz2013 Registered User. Local time Today, 21:04 Joined Dec 13, 2001 Messages 64 Dec 13, 2001 #1 I want to compact a database every time the DB is opened. Is this possible?
J Jack Cowley Registered User. Local time Today, 21:04 Joined Aug 7, 2000 Messages 2,636 Dec 13, 2001 #2 If you have Access2000 you can compact it everytime you close it. Tools > Options > General and check the Compact on Close check box. If you do not have Access2000 then take a look here. http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q209979
If you have Access2000 you can compact it everytime you close it. Tools > Options > General and check the Compact on Close check box. If you do not have Access2000 then take a look here. http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q209979
A adz2013 Registered User. Local time Today, 21:04 Joined Dec 13, 2001 Messages 64 Dec 13, 2001 #3 Do you know how to do this as an OnClick event instead of at a certain time?
J Jack Cowley Registered User. Local time Today, 21:04 Joined Aug 7, 2000 Messages 2,636 Dec 13, 2001 #4 http://www.mvps.org/access/general/gen0013.htm
A adz2013 Registered User. Local time Today, 21:04 Joined Dec 13, 2001 Messages 64 Dec 13, 2001 #5 Thanks Jack!
J Jack Cowley Registered User. Local time Today, 21:04 Joined Aug 7, 2000 Messages 2,636 Dec 13, 2001 #6 Your welcome... Good luck.
