Buck Beasom
asked on
Automating Compact and Repair
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?
Thanks.
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?
Thanks.
Please see our (free) Application Starter utility: http://www.peterssoftware.com/aps.htm
With it you can compact a backend database file when your application first opens for the day, and on a schedule.
It also copies a "master" copy of the front-end to each local computer on a schedule, which accomplishes much the same as a compact and repair of the front-end.
With it you can compact a backend database file when your application first opens for the day, and on a schedule.
It also copies a "master" copy of the front-end to each local computer on a schedule, which accomplishes much the same as a compact and repair of the front-end.
ASKER
I'm having some trouble downloading this app. It seems to be looking for an "F:" drive. Any suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See my comment in your other question about compacting from the FE.
<<Or can it be made a "Scheduled Task" in Outlook or someplace else?>>
You can call Access from Windows Task Scheduler with the /compact switch:
"C:\....\MSACCESS.EXE" "C:\...\MyDB.MDB" /compact
Jim.