Compact And Repair Utility To Fix Corrupt MS Access 2016 (.accdb) Database File

Compact And Repair Utility To Fix Corrupt MS Access 2016 (.accdb) Database File

Summary: In my last post I have discussed about 5 Easy Solutions To Repair Corrupt MS Access 2007 Database and now in this post I am going to discuss about how to repair MS Access database (.accdb) file using Compact and repair utility (manual method) as well as well as by using Access Repair and Recovery Tool (automatic method).  

Just like any other computer files, MS Access Database files are also not able to protect themselves from corruptions, damage and errors. No matter how much we try to avoid the corruptions, but still MS Access 2016 database (.accdb) files gets damaged/corrupted.

How MS Access 2016 (.accdb) Database Files Gets Corrupted?

There could be several reasons behind the damage or corruption of Access database files. As days passes by the Access database files keep on accumulating data and hence the size of the files grows quickly. Due to this the ACCDB file crosses its storage limitation and hence the corruption occurs in MS Access 2016 .ACCDB files. Other reasons could be virus infection, improper exist of applications, interruption to the Access database file, etc.

Fortunately, Microsoft offer compact and repair utility that can be used to fix any initial damage or corruption of MS Access database files.

Why We Should Use “Compact & Repair” Utility?

This inbuilt utility helps to fix the problems and corruptions that affect to the functionality of database.

1#To Reduce The Size of Database Files

When you add or update data or change its design, a database files become larger in volume and size. The growth in file size takes place due to addition of new data but some of them also come from other sources.

  • Access application creates temporary and hidden objects to perform various tasks. These temporary & hidden files still remain your database even when Access does not need them.
  • When you delete any object from the database, the emptied space is not occupied by any other items. Access still occupies the disk space even after the object is deleted.

As your database is filled with temporary and deleted objects, it is obvious that its performance will decrease. You may notice that your database opens up slowly, queries taking longer time than normal as well as other operations are taking longer time to execute.

Note: When you compact database, it does not compress your data, it simply removes the unwanted files and unused space and thereby makes your database file smaller.

2#To Avoid The Corruption in Database Files

As mentioned above that ACCDB files are prone to corruption. If you are frequently adding or editing the data in memo field the risk of corruption is high. If database files are shared over the network and multiple users are accessing the same files, then there are risks of database to get corrupt, but the risk is low.

As a matter of fact, such type of corruption occurs due to problems with Visual Basic for Applications (VBA) module that does not pose a risk of data loss. However, it poses the risk of damage in the database design such as unusable forms or lost VBA codes. You must take a note that database file corruption rarely result any data loss.

Tip: If you split and keep the databases separate that users do not have direct access, then it helps in preventing the corruption.

How To Use Compact & Repair Utility to Fix MS Access 2016 (.accdb) Database File

Note: Before you start with process, it is suggested that you must keep the backup your Access Database files that you are going to compact and repair.

Step 1: Open Access, but do not open database. Click on File.


Step 2: Point the cursor to Info and then click on Compact and Repair Database.


Step 3: Now in the Database to Compact From dialog box, browse and select the database that you want to compact and repair.

Note: Make sure that nobody is using the database file, or else the compact and repair utility will fail.

[Video]: How To Repair MS Access 2016 Database Files using “Compact & Repair” Utility

What To Do When “Compact & Repair” Fails To Fix MS Access 2016 (.accdb) Database Files?

MS-Access-2016-Database-RepairWhen built-in “Compact & Repair” utility fails then you can use professional third party Access Repair and Recovery Tool that is designed to fix, repair and recover all version of Microsoft Access database such as 2016, 2013, 2010, 2007, 2003, 2000, etc and repair both Access (.mdb & .accdb) database file format.


Steps To Repair MS Access 2016 (.ACCDB) Database Files


Whenever users face any corruption in MS Access Database files, it is always suggested that you must perform “Compact & Repair” which is a powerful utility offered by Microsoft.

However, when “Compact & Repair” utility fails and if you do not have any other option available to restore your database files, then it Access Repair and Recovery Tool is strongly recommended.

tip Still having issues? Fix them with Stellar Repair for Access:

This software ensures seamless repair & recovery of ACCDB & MDB database and restores all objects including tables, reports, queries, records, forms, and indexes along with modules, macros, etc. Fix Microsoft Access issues now in 3 easy steps:

  1. Download Stellar Access Database Repair Tool rated Great on Cnet.
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.
 Further Reading:

Guide to Compact and Repair Microsoft Access Database File: An Effective One

How to Back Up a Microsoft Access Database

[Infographics] Top 5 Manual Methods To Repair MS Access Database Files

How to Repair MS Access Database when “the compact and repair operation has been cancelled” error occur?



Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.