Routine compacts on the backend dbs?

[Access9001]

Is there a good, automated way to do this?

 

[Guus2005]

Here's a workaround

Create a bat file which runs once at 01:00 (or when no one is logged in)
In that bat file open the backend database.
In the backend database create a macro which closes the database on open.
Set the "Compact on Exit" property to true.

Run the bat file using AT or another scheduler.

Enjoy!