How to Repair Microsoft Access Database File and Recover Data

If you’ve used the Access database, you know that it’s Microsoft’s proprietary Database Management System (DBMS). And just as Microsoft’s other applications, it’s efficient as well as very user-friendly. MS Access has a relational MS Jet Database Engine with development tools running at the back and an easy to grasp user interface at the front. The ease of use it offers makes this DBMS a preferred choice for many corporates. However, database files are often plagued by corruption, which can pose a threat to the extremely vital data present in them. MS Access is no different and often faces corruption. This article is helpful for Microsoft Access database repair and you understand the reasons behind MS Access database corruption and the ways in which it can be resolved.

Special Tips – Don’t forget to check out this MDB repair article if you are using MS Access 2003 or lower versions.

Access Database Repair

Reasons for Access Database Corruption

When the binary file format of a database encounters an error, database corruption occurs. In such a case, users might face random errors or difficulty in using the database. The Jet Database Engine of Access auto-fixes minor issues that crop up in the database from time to time while reading and writing data normally. Due to this, in most cases, you may never find out that something went wrong! This is both good and bad. Good because your work is not interrupted, bad because corruption can become worse with time if not treated. Hence it is important to understand every aspect of Access database corruption.

Here are the main reasons behind it:

  1. Frequent edits to data in Memo fields increases the chances of Access database corruption. It mostly results from a problem with a VBA module and does not pose a risk of data loss. However, it does pose a risk of database design damage.
  2. Interrupted change to data — because of network service loss for example — causes Access to mark the database file as corrupted. The file can be repaired, but some data may be missing after the repair is complete.
  3. If a Virus infects a file needed by the Access database, as soon as that file is used when the database opens, the infection will spread to the database and corrupt it.
  4. Hardware failures like lost packets on network cards and bad sectors on hard drives can cause database corruption.
  5. Improperly designed or installed third-party plug-ins for Access can corrupt the database.
  6. If multiple users of the same database have different Jet service packs and updates installed, minor differences in the mdb file format and file-locking mechanisms can cause database corruption.
  7. A few bugs in Access and Jet software are sometimes themselves responsible for corruption.
  8. Though it happens very rarely, improper shutdown of the system while some activity is being performed on the database can lead to its corruption.

Repairing Access database and recovering data

Generally, when database corruption occurs, the only solution we can think of is sending the database to an Access data recovery company or calling their experts over. However, what we don’t realize is that sometimes, the corruption is minor enough to be handled by us ourselves. Here are some manual techniques to rectify database corruption:

  1. Restore the database from a backup file – This is why backups are very very important!
  2. Delete the .ldb file that is auto-created by the Jet database engine when the database is opened.
  3. Use the Jet Compact Utility that has been specifically designed to rectify minor corruptions in Access database.
  4. Remove all compiled VBA code from the database. This can be done using this command line switch from Microsoft:

C:\Program Files\Microsoft Office\Office\MsAccess.exe /decompile C:\DatabasePath\FileName.mdb

Note: You may need to change the path shown above for MsAccess.exe if you installed it to a different location.

  1. Use the built-in Access 2010 ‘Compact & Repair‘ feature. Here are the steps to fix Access database corruption using this feature:
    • Open MS Access (not the database file) and go to Database Tools -> Compact & Repair Database.
    • Locate the corrupted database file and click on Ok.
    • The selected database file will be rectified on completion of the process

Compact and Repair database

  1. Import the corrupt database into a new Access 2010 database file by using the following steps:
    • Open MS Access and create a new database file.
    • Click on Access to Import Access database under the External Data tab.
  1. In the next window that pops-up, click on Browse and locate the database file while is to be imported.
    • Specify the place and technique to store data in the new database and click on Ok.
    • From the next window select all database objects that you want to import and click on Ok.
  1. If even after all the above techniques, the database corruption persists, the recommended solution would be to buy a premium quality third-party Access database repair software or else send the database to an Access repair company.

Steps to repair Microsoft Access database file by Stellar Repair for Access tool:

Free Download

buy now

 

 

  1. Download and install Stellar Repair for Access.
  2. Select the corrupt file using ‘Browse’ button. You can also search the corrupted MDB or ACCDB files from the appropriate drive by selecting the drive and click on ‘Search’ button.

Select access database file

  1. Check the “Scan for deleted records” checkbox to include the deleted records for recovery.

Scan for deleted records

  1. Click on the Repair button to start the repairing process.

Repair Access Database

  1. After completion of the repairing process, a confirmation message will appear on the screen. Click on OK.

Repair access database successfully

  1. In the left pane, database objects will be listed in the tree form. Click on the objects to see the preview.

Preview of repaired database

  1. To save the repaired data, click on the Save button and choose the location.

save repaired access database

  1. Select destination to save the repaired database file.

Choose location to save database

  1. The file will be saved at the desired location.

File saved successfully

Concluding Lines

Now that you know about Access database corruption, its reasons, and solutions, do give them a try before rushing to the repair company. It might save your time and money.

Comments(83)
  1. Laura Ken June 29, 2015
    • Abhay June 30, 2015
  2. Nathan Barvo July 14, 2015
  3. jyoti July 15, 2015
  4. kohler foyde August 13, 2015
    • jyoti August 17, 2015
  5. Alden September 8, 2015
  6. Welma September 9, 2015
  7. Ivo September 15, 2015
  8. Phil Roggers September 29, 2015
  9. Dwane Cliff October 16, 2015
    • Jyoti Prakash October 16, 2015
  10. Anthony Stephens October 19, 2015
  11. Elijah Matthew October 26, 2015
    • Jyoti Prakash October 26, 2015
  12. Jayden Turner October 30, 2015
    • Jyoti Prakash November 5, 2015
  13. Petrick L. November 17, 2015
  14. Adrian November 24, 2015
  15. Sims Mateo December 8, 2015
    • Jyoti Prakash December 10, 2015
  16. Zoey Campbell December 16, 2015
    • Jyoti Prakash December 17, 2015
      • Zoey Campbell December 21, 2015
  17. Jesica Brown January 19, 2016
    • Jyoti Prakash January 20, 2016
  18. Aaron White May 6, 2016
  19. Joanna Wise June 20, 2016
  20. Angela Ward July 20, 2016
  21. Rahul August 7, 2016
  22. Ethane August 30, 2016
  23. Marco Pezzutti September 7, 2016
    • Jyoti Prakash November 7, 2016
  24. James Brouwer October 6, 2016
    • Jyoti Prakash November 7, 2016
  25. Eithne White January 20, 2017
    • Jyoti Prakash January 23, 2017
  26. Mahira K. February 22, 2017
  27. Ashwin February 22, 2017
    • Jyoti Prakash February 23, 2017
  28. Rohit March 28, 2017
  29. Rohit March 28, 2017
    • Jyoti Prakash March 30, 2017
  30. Woona Ramesh Kumar May 19, 2017
  31. Jamie Anderson June 29, 2017
  32. Lauren Wills June 29, 2017
  33. Afzaal August 8, 2017
    • Jyoti Prakash August 10, 2017
  34. NItesh September 9, 2017
    • Jyoti Prakash September 12, 2017
  35. Stuart Joseph Taylor October 10, 2017
    • Rajan Singh October 11, 2017
  36. John October 29, 2017
    • Eric Simson October 31, 2017
  37. Antony November 9, 2017
    • Eric Simson November 10, 2017
  38. Jay November 10, 2017
  39. Luis November 12, 2017
    • Eric Simson November 13, 2017
  40. Zachery November 22, 2017
    • Eric Simson November 23, 2017
  41. Tony December 4, 2017
    • Eric Simson December 5, 2017
  42. Steve Jowett February 12, 2018
    • Eric Simson February 14, 2018
  43. Vincent February 26, 2018
    • Eric Simson February 28, 2018
  44. Emma May 15, 2018
    • Eric Simson May 16, 2018
  45. Kunjan Sompura May 16, 2018
    • Eric Simson May 17, 2018
  46. Megan May 25, 2018
    • Eric Simson May 25, 2018
  47. Sarah June 27, 2018
    • Eric Simson June 29, 2018
  48. Rosa P. July 15, 2018
    • Eric Simson July 16, 2018
  49. Elicia July 20, 2018
    • Eric Simson July 20, 2018
  50. Mark Smith November 21, 2018

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.