How to fix corrupted Microsoft Access databases

Matthew Adams By: Matthew Adams
4 minute read
Microsoft Office Access corrupted database fix

For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patented Technologies (requires upgrade).


Steps to fix Microsoft Access database problems

  1. Select the Compact and Repair Database Tool in Access
  2. Open the Jet Compact Utility
  3. Fix Access Database Files at OfficeRecovery.com
  4. Fix Corrupted Access Database With Database Repair Software

Access is one of the industry’s foremost database applications that’s included within the Microsoft Office suite. Access databases might be essential files for some users as they retain records, so it’s a good idea to keep a database backup as a precaution for file corruption. Yet, there are probably some users who don’t back up their database files; and they’ll need to repair corrupted Access MDB or ACCDB files. If your Access database is corrupted, and you don’t have a backup handy, check out some of the fixes for it below.

Solve Microsoft Access database corruption issues

1. Select the Compact and Repair Database Tool in Access

First, check out the Compact and Repair Database tool included within Access. That tool can repair corrupted Access database files. This is how you can fix databases with the Compact and Repair Database tool.

  • Open the Access application.
  • Select the Database Tools tab.
  • Then click the Compact and Repair Database option on the tab.Compact and Repair Database
  • A Database to Compact From window will then open from which you can select a database file to repair.
  • Press the Compact button.
  • Next, enter a new file title in the Compact Database Into dialog box that opens; and select a folder to save it to.
  • Click the Save button. Thereafter, you will have a fresh database that you can open in Access.

— RELATED: Fix: Potential Windows Update Database Error Detected

2. Open the Jet Compact Utility

There’s also a separate Microsoft Jet Compact utility (Jetcomp) that Access users can repair corrupted databases with. Jetcomp is pretty similar to the built-in Compact and Repair tool in Access as it compacts databases. However, Jetcomp is certainly worth noting if the Compact and Repair Database utility in Access doesn’t repair your MDB or ACCDB file.

  • You can click Download JETCOMP.EXE now on this page to save the utility to a folder.
  • Click JetCU40.exe in the folder you saved it to to open the window shown directly below.

  • Click the Browse button to select a folder to extract Jet Comp to, and click the OK button.
  • Open the folder that includes the extracted utility, and click JetComp.exe to open the Database Compact Utility 4.0 window.


For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patented Technologies (requires upgrade).

  • Click the button for the Database to Compact From box to select a corrupted database.
  • Then click the button for the Database to Compact Into box to choose a path to save the newly compacted database to. Add a file title for the database to the end of the path if required.
  • Press the Compact button.

3. Fix Access Database Files at OfficeRecovery.com

OfficeRecovery.com includes a few web tools that MS Office users can fix files with. You can fix MDB and ACCDB files with the Repair Access Database ONLINE utility at OfficeRecovery.com. Click here to open Repair Access Database in your browser. Then press the Choose file button to select a corrupted database, and click the Secure Upload and Repair button to fix it.

— RELATED: Fix: Windows 10 ‘Unexpected error from external database driver’

4. Fix Corrupted Access Database With Database Repair Software

You can also fix corrupted Access files with third-party database repair software. Stellar Phoenix Access Database Repair is one package specifically for fixing MDB and ACCDB files. That utility is retailing at $99, and you can try out a demo version by clicking the Free Demo button on this webpage. You can fix databases with that software as follows.

  • Open the Stellar Phoenix Access Database Repair window.
  • Click the Select File button to select a database to fix.
  • Select the Scan for deleted records option above the Help button.
  • Then press the Repair button to initiate the Access database repair.
  • A dialog box will open to confirm when the software has repaired the database. Click the OK button on that window.
  • Thereafter, the software shows you previews of the repaired database tables. Select the Save option on the File tab to save the repaired database.

So that’s how you can fix corrupted MS Access database files. First, check out the built-in repair option in Access and Jet Comp utility. If those don’t fix the database, then you might need some third-party software.

RELATED STORIES TO CHECK OUT:

For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patented Technologies (requires upgrade).

Discussions

Next up

Surface Pro 3 gets new security updates, install goes smoothly

Giles Ensor avatar. By: Giles Ensor
2 minute read

After recent bad news stories about updates released by Microsoft for Windows 10, that you can read here and here, it is refreshing to read (or […]

Continue Reading

Best Windows 10 antivirus software to use in 2018

Radu Tyrsina By: Radu Tyrsina
7 minute read

Update – 2018 will soon come to an end and we already have a guide on what is the best antivirus you should get in […]

Continue Reading

These features are out for good with Windows 10 version 1809

Sovan Mandal avatar. By: Sovan Mandal
2 minute read

Microsoft is all set to launch its next big update, Windows 10 version 1809 in October. While that should be a nice piece of news […]

Continue Reading