Unanswered: Scheduling Comact and Repair Utility to run itself?
Is there any way to set up the "Compact and Repair Database" function to automatically run by itself, say in the middle of the night?
I have a multi-user database with 100,000+ records used by about 20 users. The main data entry form involves 11 subforms each writing to separate tables. That database has been needing to be compacted more frequently recently for efficiency.
However, more users are now wanting to work after hours, so it is becoming a hassle to get everyone to shut down at 5pm so I can run this then. Also, I cannot stay late every time this needs to be done--and for now i'm the only one who can do it.
Is there any way to get this to run automatically? Is it necessary to buy additional software?