Repair Access Database – Compact & Repair Utility

MS Access is a popular database management system provided by Microsoft. MS Access has its own format based on Access Jet Database Engine to store data and information. An Access database is prone to corruption due to numerous reasons. Corruption makes your Access database inaccessible. You can try Compact and Repair utility to repair Access database. Also, you can try a professional database recovery tool.

Compact and Repair Utility

Microsoft provides a built-in feature, known as Compact and Repair, in MS Access program to optimize Access’ performance and minimize database corruption. It is strongly recommended to compact and repair file server databases like Access/JET MDB and ACCDB files on a regular time period. Compacting a database also avoids bloating which may occur during the addition or deletion of data in the database file.

As Compact and Repair is a built-in feature in Access, it can be manually performed with ease. Microsoft Access is available with different versions, so the location of this command varies version to version.

How to repair Access database? 

Compact and Repair Database in Microsoft Access 2013

There are two ways to use the Compact and Repair feature in Microsoft Office 2013:

Step 1: Launch Microsoft Access 2013 on your system.

Step 2: Go to the DATABASE TOOLS tab > then click Compact and Repair Database.

Note: You should use this method if database file is not opened.

Another way to use Compact and Repair feature is:

Step 1: Launch Microsoft Access 2013 on your system.

Step 2: Go to Info > and then click Compact & Repair Database.

Compact and Repair database in Microsoft Access 2010

Like Access 2013, there are also two ways to use Compact and Repair feature in Microsoft Access 2010:

Step 1: Launch Microsoft Access 2010 on your system.

Step 2: Go to the Database Tools tab > then click Compact and Repair Database.

Note: You should use this way if database file is not opened.

Another way to use Compact and Repair feature is:

Step 1: Launch Microsoft Access 2010 on your system.

Step 2: Go to Info > and then click Compact & Repair Database.

Compact and Repair database in Microsoft Access 2007

You can use Compact and Repair in Access 2007 in this way:

Step 1: Launch Microsoft Office 2010 on your system.

Step 2: Click Office button > Manage > Compact and Repair Database.

Compact and Repair database in Microsoft Access 2003

You can use Compact and Repair in MS Access 2003 in this way:

Step 1: Launch Microsoft Office 2007 on your system.

Step 2: Go to the Tools tab > click Database Utilities > Compact and Repair Database…

The Compact and Repair feature of Microsoft Access is highly effective when users want to repair Access database files.

Also Read: MDB Viewer tool to Open & Read Access Database Files