automating database compact

[DoniFromMars]

I'd like to compact my database at a specific time every night without having to do it manually from the menu.
VBA has 'docmd.RunCommand acCmdCompactDatabase' which looks promising but you can’t compact the db that is running the code and I can't find where to specify a different db.
Help!

 

[dhookom]

You can start Access with a command line option "/Compact" to compact and close the database. You can use any of a number of different scheduling applications to perform this.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Bandenjamin]

Took me a while to find it but I have had a lot of luck using faq705-2852

--Dan
Whenever you find yourself on the side of the majority, it is time to pause and reflect.
Mark Twain

 

[mp9]

The Handy Access Launcher provides a quick and easy way of automating compaction, and other admin tasks too.