File Repair

How to Use Jet Compact Utility to Compact and Repair Access Database?

Summary: This article will guide you on ‘how to use Jet Compact Utility to Compact and Repair Database’. Also, it will describe what is Jet Compact Utility, its limitations, and an alternative for repairing the corrupt Access database.


Table of Contents

What is Jet Compact Utility?

Compacting and Repairing Access Database with Jet Compact Utility

Downsides to Using Jet Compact Utility

Best Alternative to Microsoft Access Jet Compact Utility

Conclusion

Microsoft Access database .mdb (or .accdb) file can become corrupt due to an increase in the database file size, simultaneous use of the Access database by multiple users, error in binary file format, or hardware and software errors.

Also Read: Top 10 Access Database Corruption Causes

Corruption in an Access database can turn database files inaccessible, forcing you to stop your work. Not repairing the db on time may lead to extended database downtime and data loss.

Quick Solution: Use Stellar Repair for Access software to repair severely corrupted Access database (.ACCDB and .MDB) files in just a few clicks, without any technical assistance. The software can also help recover all the database objects, including deleted records, password-protected forms, and modules, etc. Download the free trial version of the software to scan and preview recoverable Access database objects now.

Free download Stellar Repair for Access

Usually, when a database gets corrupted, it is recommended to restore it from the last known good backup copy. But, if the backup copy isn’t available or is not updated, Microsoft offers some tools to repair the database. MS Access built-in Compact and Repair utility is one such tool that helps fix corrupt db. Besides this built-in tool, Microsoft released a standalone utility, called the Jet Compact Utility (or JETCOMP.exe), to resolve issues with Access database .mdb files.

Before we discuss about the Jet Compact Utility, check out some tell-tale signs of Access database corruption:

  • You receive any of these error messages:
  • Unrecognized Database Format
  • “You do not have the necessary permissions to open this object. Please contact your system administrator.”
  • “MDB isn't an Index in this table.”
  • "Microsoft Jet database engine stopped the process because you and another user are attempting to open the same file…”
  • You get prompted to enter a database password even when you haven’t set one.
  • Microsoft Jet Engine cannot open the db file.
  • Access crashes on opening MDB or ACCDB files.

What is Jet Compact Utility?

Microsoft Jet Compact Utility, also called JETCOMP.exe, is a freeware utility to compact Access databases created by using Microsoft Jet database engine 3.x and 4.x. Also, running JETCOMP.exe together with the Jet database engines 3.x and 4.x may help in recovering corrupted databases. It may even restore some databases that Microsoft’s native Access ‘Compact and Repair’ utility and ‘CompactDatabase’ method cannot recover.

The MS Access built-in ‘Compact and Repair’ and the ‘CompactDatabase’ method try to open and close a database before compacting it. In case these methods cannot reopen the database, a compact process will not run, preventing the recovery of that database. In contrast, the Jet Compact Utility does not attempt to open and close the database before compacting. And so, JETCOMP.exe may be able to recover databases when methods such as Compact and Repair does not work.

Compacting and Repairing Access Database with Jet Compact Utility

Now let’s discuss how to use the JETCOMP.exe Utility to compact and repair an Access db.

Prerequisites

Make sure you have the following products installed on your system for running the JETCOMP.exe tool:

  • Microsoft Office 97/2000/XP
  • MS Access 97/2000/2002
  • Microsoft Visual Basic 5.0 version including MS Jet database engine 3.5 or 4.0
  • Microsoft Visual Basic 6.0 version including MS Jet database engine 3.5

Steps to Use Jet Compact Utility to Compact and Repair Access Database

Notes - Before you run the Jet Compact tool, make sure:
  • The database file you are trying to repair is closed.
  • There are no active users before you run the utility.
  • You have backed up your MDB file (even if it’s corrupt) to prevent data loss.

Step 1: Download the JETCOMP.exe package from the Microsoft Download Center.

Step 2: The Jet Compact Utility 4.0 dialog box is displayed. Type or browse the location where you want to save the JETCOMP.exe file.

Jet Compact Utility 4.0 Window

Figure 1 - Jet Compact Utility 4.0

Step 3: Navigate to the location where you saved the file.

Step 4: Double-click JETCOMP

Open JETCOMP Utility

Figure 2 - Find and Open JETCOMP

Step 5: In the dialog box that appears, do the following:

  • Click the three dots corresponding to the ‘Database to Compact From (Source)’textbox to browse and select the Access database file you want to fix.
  • Next, click the three dots next to the ‘Database to Compact Into (Destination)’ textbox to select the location and database name wherein you want to save the recovered file.

TIP: Avoid compacting into an existing database even if it is empty, or else it may return an error.

  • Select the appropriate option under the ‘Additional Compact Options’ tab.
  • Click Compact.

Select Access Database to Compact

Figure 3 - Select Database to Compact

The corrupted Access database file will get repaired.

Downsides to Using JETCOMP.exe

The following are some limitations of the Jet Compact Utility:

  • It only works with MS Access database (.mdb) file.
  • May fail to fix severely corrupt Access databases.
  • Cannot fix all types of Access database errors.
  • Cannot recover deleted tables and records.
  • Recover corrupt databases of Access 2002 and older versions.
  • Running JETCOMP 4.0 utility occasionally throw the “Error Compacting database” message. 

To overcome these limitations, you need a more reliable Access repair tool than JETCOMP to repair the Access db.

Best Alternative to Microsoft Access Jet Compact Utility

Access repair software from Stellar® serves as the best alternative to Jet Compact Utility, and here’s how:

  • Repairs both MDB and ACCDB files of the Access database.
  • Can repair severely corrupt Access database files.
  • Handle common Access database errors such as inconsistencies in the database design, unrecognized database format, etc.
  • Recovers deleted tables, records, attachments, etc.
  • Supports Microsoft Access 2019, 2016, 2013, 2010, 2007, and older versions.

Free download Stellar Repair for Access

Stellar Repair for Access software helps recover all the database objects, including tables, indexes, queries, forms, macros, reports, etc. and saves them in a new database. It even performs recovery of relationships and data linked through different sources from corrupt tables.

Steps to Repair Access Database by using Stellar Repair for Access Software

To repair corrupt Access (MDB/ACCDB) files, download and install Stellar Repair for Access software. Run the software and follow these steps:

Step 1: Browse the corrupt database file that you want to repair from the software’s main interface.

Notes:
  • If you cannot find the location of the database file, click ‘Search’ to find and select the file.
  • To perform recovery of deleted records, make sure that the “Scan for deleted records” checkbox is checked.

Select Corrupt Access Database File

Figure 4 – Browse or Search Corrupt Access Database File

Step 2: Once the targeted Access database file is selected, choose Repair to begin the repairing process.

Start Access Database File Repairing

Figure 5 – Initiate Access Repairing Process

Step 3: When the ‘Repairing of selected database completed’ message appears, click OK.

Access Database Repair Complete Message Box

Figure 6 – Database Repair Complete Message

Step 4: The software previews recoverable Access database objects in a tree-like structure. All the recovered database objects get listed in the left panel of the Preview window. Click on any db object to see its preview in the right panel.

Access Database Preview

Figure 7 – Access Database Preview

Step 5: For saving the repaired database file, select the Save Database option on the File menu.

Click Save Database File Option

Figure 8 – Save Database Option

Step 6: Select a ‘default’ or a ‘new’ destination to save the repaired database file, and then click OK.

Save Repair Access Database File

Figure 9 – Save Repaired File at a Desired Location

Step 7: Once the file gets saved, a message window will pop-up. Click OK to complete the repair process.

Repaired File Location

Figure 10 – Repaired File saved at the desired location message

Conclusion

In this article, we outlined common reasons that make an Access database damaged (or corrupt). Also, we discussed how to use Jet Compact Utility to compact and repair the Access database. Additionally, we talked about the limitations of using the JETCOMP.exe utility and the best alternative to repair and recover objects and data from a severely corrupt Access database. In case the Jet Compact Utility fails restoring the db, you can always take the help of a professional Access database repair software. One such software you can trust to repair corrupted database files is Stellar Repair for Access. It comes with several advanced features, such as the ability to check a real-time preview of recoverable database objects for precise recovery. It can also help restore password-protected forms and modules.   

 

76% of people found this article helpful