Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Automating Compact and Repair

Posted on 2013-05-31
4
Medium Priority
?
376 Views
Last Modified: 2013-07-08
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.
0
Comment
Question by:Buck_Beasom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 58
ID: 39210670
<<Is there a way to either automate the "Compact and Repair" of the back end databases to put in behind a Utilities button?>>

 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.
0
 
LVL 12

Expert Comment

by:pdebaets
ID: 39210690
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.
0
 

Author Comment

by:Buck_Beasom
ID: 39213610
I'm having some trouble downloading this app. It seems to be looking for an "F:" drive. Any suggestions?
0
 
LVL 12

Accepted Solution

by:
pdebaets earned 2000 total points
ID: 39213647
Open the aps2000.mdb file while holding down the shift key. See the readme.txt file for detailed instructions.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question