Compact and repair automatically

[Romper]

Hi all,
I remember seeing a thread regarding setting up an automated Compact & Repair process, but I can't seem to find that thread now. Could someone please direct me to a reliable version of this type of process.
Thanks.

 

[Galaxiom]

Access Options > Current Database > Compact on Close

 

[John Big Booty]

You can also use the following, VBA;

        CommandBars("Menu Bar"). _
        Controls("Tools"). _
        Controls("Database utilities"). _
        Controls("Compact and repair database..."). _
        accDoDefaultAction

If you only need to compact and repair to a schedule.

 

[Galaxiom]

Another way is to run the compact command using the Windows Scheduler.

"Path to MSAccess.exe" "Path to file for compacting" /COMPACT

 

[Romper]

Thanks very much.