Force a compact repair.

[Matoco1]

I have a database which is split into FE & BE, the BE is locked open by a forms server.
I have a way to force a close but have to contact someone to reopen it.
I would like to be able to code a compact and repair to run during the night ideally without having to close access.

Access 2000 by the way.

 

[Galaxiom]

Close Access then use Windows Scheduler to run a command (batch) file.

<path to access>\msaccess.exe <path\file to compact> /Compact