Scheduling Compact database

[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 to db that is running the code and I can't find where to specify a different db.
Help!

 

[longhair]

DoniFromMars,
if i remember correctly there is a command line switch to compact the db when you open it. search access help for compact and startup command line options. put the command line in a .bat file and use scheduled tasks to run it when you want.
regards,
longhair

 

[WinblowsME]

Schedule a task to run the VBScript in the following page.

http://www.databasejournal.com/features/msaccess/article.php/10895_1494251_2

 

[combo]

You can force 'compact&repair' command action:

Sub CompactThisDB()
Dim conCompact As Office.CommandBarControl
Set conCompact = CommandBars.FindControl(Id:=2071)
conCompact.accDoDefaultAction
End Sub

combo

 

[mp9]

Take a sneaky peek at the Handy Access Launcher], which does all this and more.