Automatic Compact

[Jade]

Hi There,

I was wonder if anyone knows how to setup a database to automatically compact? I would like it to compact automatically once a week if possible

 

[Jack Cowley]

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q209979

 

[catt]

In Access 2000 you can just check the "Compact on Close" checkbox on the General tab of the Access Tools/Options dialog box. This will allow the compacting to be automatic everytime you close.

 

[saleem]

hi..i hav same type of problem...i check the "Compact on Close" checkbox on the General tab of the Access Tools/Options dialog box....but then it takes too long to close...i have a moduled that whenever run make and drop tables and generate report..i want to run compact whenever user run this module...i try to use this...

runcommand accmdcompactdatabase

but it says u cant compact when macro or module running

any help

 

[Peter D]

Here are some tools that may help when trying to compact an open database:

The TSI SOON utility will close a database, compact it, and then open it again (it also copies NT file permissions to the new file):
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8

Another utility is Compact Current MDB From Code:
http://briefcase.yahoo.com/lylefair

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com