I have some "Back End" databases sitting on a server. They are accessed by a user population of about a dozen folks. Some of the processes - and the sheer size of the tables - is causing the .accdb files to get bloated. Right now I am doing Compact and Repair manually on the Back End tables and have set the Front End to "Compact on Close."
Is there a way to either automate the "Compact and Repair" of the back end databases to put in behind a Utilities button? Or can it be made a "Scheduled Task" in Outlook or someplace else?