Improve company productivity with a Business Account.Sign Up

x
?
Solved

Automating Compact and Repair

Posted on 2013-05-31
4
Medium Priority
?
384 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
  • 2
4 Comments
 
LVL 59
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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

595 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