Scheduling the Compacting and Repairing Of Access2002 database

[jairiana]

Does anyone know the string you need to set up a scheduled Compact and Repairing of an Access Database? Need to schedule this at night when everyone is off the network.

 

[FancyPrairie]

I would use Windows task scheduler to do this. Goto Start|Programs|Accessories|SystemTools

 

[jairiana]

I have gotten that far and got it to open the DB but don't I need a string to tell it to actually perform the Compact & Repair?

 

[jairiana]

I have gotten that far and got it to open the DB but don't I need a string to tell it to actually perform the Compact & Repair?

 

[FancyPrairie]

Use the Startup Command Line Option /Compact (see on-line help). Something like this:

"path\msaccess.exe" "path\yourdatabase" /Compact

 

[mp9]

Jairana - as a more intuitive alternative to Widnows task scheduler, try the freeware Handy Access Launcher (HAL) utility (

http://www22.brinkster.com/accessory/resources/001.shtml

or

http://www.geocities/com/waddly/accory.html

HAL lets you schedule compacts, repairs, macro runs, and so, plus it uses fewer system resources that Windows task scheduler, plus it masks database password info.

http://www22.brinkster.com/accessory/