Access Database Repair Blog

How to reduce Access database corruption 6

Did you make plans to implement some of the tips mentioned in the previous posts during the weekend? That would be great. I know that you’ll have to spend some money with following a couple of those tips that I’ve mentioned. It will all be worth it in the end, because the money that you usually spend on Access database recovery whenever you get a corrupt MDB will be spent on something that will increase your business’ productivity.

For tip #6, this is cost-free on your part, because it is already in Microsoft Access. All you have to do is use it regularly. So, what is it then? I won’t keep you waiting! Tip #6 is…

Use “Compact and Repair” on your databases regularly.

The Microsoft Access application has a built-in “Compact and Repair Database” utility. Using this on all your databases regularly will help avoid corruption in your databases, and also improve the performance of your application. Apply this method during times when there is the least activity in your databases, but on weekends when there is no work is most preferable.

How to use “Compact and Repair”

  • Open MS Access.
  • Click on the Tools menu. Choose “Database Utilities.”
  • Click on “Compact and Repair Database.”
  • A window named, “Database to Compact From” will open.
  • Choose the database that you’re going to Compact and Repair. Click on “Compact.”

It’s easy, right? Make sure to apply this method in your office databases so that frustration from a corrupt database will be avoided.

Dieser Beitrag wurde am Monday, 24. September 2007 um 08:42 Uhr veröffentlicht und wurde unter der Kategorie MS Access Corruption abgelegt. Du kannst die Kommentare zu diesen Eintrag durch den RSS-Feed verfolgen. Du hast die Möglichkeit einen Kommentar zu hinterlassen, oder einen Trackback von deinem Weblog zu senden.

«  –  »

No Comments »

No comments yet.

Leave a comment

You must be logged in to post a comment.







WP-Design: Vlad -- Powered by WordPress -- XHTML 1.0