Can you compact and repair as a scheduled task

[jeep2001]

I would like to compact and repair my databases automatically over the weekend, can i do that from a scheduled task....Access 2003. I think so...
Can I do that in a DoCmd.

 

[PHV]

Create a windows scheduled task with a command line like this:
"\path\to\msaccess.exe" "\path\to\database.mdb" /compact

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ProgramError]

Try the two following links supplied by datapig

http://www.datapigtechnologies.com/flashfiles/compactonclose.html

and there's a download too

http://www.datapigtechnologies.com/downloads/CompactExample.zip

Ian Mayor (UK)
Program Error
There's ALWAYS more than one way to skin a cat!
But only one way to get it RIGHT!