1. Home
  2. Database
  3. Microsoft Access
  4. Microsoft Access Problems
  5. Access Database is Corrupted – Microsoft Access Problem

Access Database is Corrupted – Microsoft Access Problem

Summary

This article explains the symptoms and causes for a corrupted Microsoft Access database, and what to do about it.

Symptoms

A corrupted database can lead to several problems including:

  • Database will not properly open without error messages or may not open at all
  • Records may contain incorrect data or irrelevant data
  • Functions within the database may not work (sorting, adding/deleting records, etc)

Explanation

A corrupted database needs to be rebuilt. We always recommend making a backup copy of the database before attempting any work on it. Access has several tools built into the software to facilitate rebuilding a database. One of the most effective is the “Compact and Repair Database” function.

A common problem in manipulating the original file (after a backup is complete) is that Access has ‘locked’ the database due to other users accessing the same database.  Sometimes the ‘other user’ is a Windows service running (such as MCL).

Solution

Make sure all users including possible services are not connected. A reboot of the system will usually remove users. Using the Services Manager in Windows can help stop the services that might be locking the database. A reboot will not stop the services if the services are set to automatically start when the computer starts (this is the typical setting).

Additional Comments

Related Articles:
Rebuild a Database with the “Compact and Repair Database” Feature – KBA-01417-P0N4N6
Enable or Disable a Service in Windows – KBA-01212-V9N6Y4

Updated on September 26, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support