Techdee
No Result
View All Result
Saturday, March 25, 2023
  • Home
  • Business
  • Tech
  • Internet
  • Gaming
  • AI
    • Data Science
    • Machine Learning
  • Crypto
  • Digital Marketing
  • Contact Us
Subscribe
Techdee
  • Home
  • Business
  • Tech
  • Internet
  • Gaming
  • AI
    • Data Science
    • Machine Learning
  • Crypto
  • Digital Marketing
  • Contact Us
No Result
View All Result
Techdee
No Result
View All Result
Home How to

How to Fix Corrupted Microsoft Access Database?

by msz991
February 9, 2021
in How to, Tech
5 min read
0
How to Fix Corrupted Microsoft Access Database?
239
SHARES
3k
VIEWS
Share on FacebookShare on Twitter

When working with an Access database, events such as abrupt system shutdown in the middle of a write operation, virus attack, drive errors, etc., may leave the database (.ACCDB/.MDB) files damaged (corrupted).

A corrupted database file may not open at all, or it may generate random errors identifying corruption. Whatever be the case, it is necessary that the issue is resolved at the earliest to avoid downtime and data loss.

Table of Contents

  • Methods to Fix Corrupted Microsoft Access Database
    • Method 1: Use MS Access ‘Compact and Repair’ Utility
      • Repairing an Open Database by using Compact and Repair
      • Repairing Inaccessible Database by using Compact and Repair
    • Method 2 – Use Microsoft Jet Compact Utility (JETCOMP.exe)
  • Workarounds to Fix Corrupted Microsoft Access Database<2Fstrong>
    • 1. Delete the Access Database Lock Files (ACCDB/LDB)
    • 2. Import Objects to a New Database
  • Conclusion

Methods to Fix Corrupted Microsoft Access Database

Following are the methods that can be used to repair corrupt Access database:

Method 1: Use MS Access ‘Compact and Repair’ Utility

NOTE: If you have already tried compacting and repairing the database but the issue still persists, skip to the next method.

MS Access has a built-in utility, called the ‘Compact and Repair’ utility, which helps in compacting and repairing database files. The utility not only fixes the corrupt database but also helps enhance the performance of the database.

If you want to know more about Compact and Repair utility, click here.

The steps to compact and repair a database may vary depending on whether the database is accessible (i.e., it can open) or inaccessible.

Repairing an Open Database by using Compact and Repair

  1. Click File > Info.
  2. Choose the Compact & Repair Database.
You May Also Like  That Art of the Startup: Using Best-Practice Methods to Get Ahead

MS Access will now create and open a copy of the compacted and repaired database.

Repairing Inaccessible Database by using Compact and Repair

  • Launch your MS Access application.
  • Double-click Blank desktop database.

Blank desktop database.

Figure 1 – Open Blank Desktop Database

  • A blank database gets displayed. Close the db table by clicking the cross (X) sign.

Close the Database Table

Figure 2 – Close the Database Table

  • Go to Database Tools, and select the Compact and Repair Database option on the Tools menu.

Select Compact and Repair Database

Figure 3 – Select Compact and Repair Database

  • In Database to Compact From the dialog box, browse the database you want to compact and repair and double-click it.

A copy of the compacted and repaired DB will get saved in the same location where the original db resides.

Method 2 – Use Microsoft Jet Compact Utility (JETCOMP.exe)

Note: This utility only works for Access database .mdb files.

If you’re using Access 2010 or an earlier version, running the JETCOMP.exe utility may help in recovering the corrupt database (MDB) file that even the MS Access built-in tool (discussed in Method 1 above) cannot recover.

Steps to use the Jet Compact Utility to repair MDB file are as follows:

Step 1: Download the JETCOMP.exe package available for download in Microsoft Download Center.

Step 2: In the dialog box that appears, type the location where you wish to save the JETCOMP.exe file or click Browse to select the location. Click OK.

Jet Compact Utility 4.0

Figure 4 – Jet Compact Utility 4.0

Step 3: Browse to the location where you saved the extracted .exe file, and search for JETCOMP.

You May Also Like  How to Make Game on Scratch

Step 4: Double-click the JETCOMP option.

Open JETCOMP

Figure 5 – Open JETCOMP

Step 5: In the window that pops-up, click the three dots under ‘Database to Compact From (Source)’ to browse and choose the MDB file you want to fix.

Select Database to Compact

Figure 6 – Select Database to Compact

Step 6: Next, click the three dots under ‘Database to Compact Into (Destination)’ to choose the location where you want to save the recovered file.

Step 7: Select one of the options under Additional Compact Options.

Step 8: Click Compact.

The corrupt Access database (MDB) file will get repaired.

If none of the above methods works use an Access Database Repair tool such as Stellar Repair for Access to fix the corrupted Microsoft Access database and restore its data. The tool can handle all types of Access database corruption errors. It recovers all the database objects, including tables, deleted records, macros, indexes, linked tables, etc.

Workarounds to Fix Corrupted Microsoft Access Database<2Fstrong>

There are a few workarounds you can try o repair and recover a damaged database:

1. Delete the Access Database Lock Files (ACCDB/LDB)

When opened for shared use, Access automatically creates a lock file to keep a track of all the users accessing the DB. The file extension for ACCDB database files is “.laccdb” and the “.ldb” file extension is used for MDB files. The “.laccdb” or “.ldb” lock file gets automatically deleted when a user exits the MS-Access program.

The lock file won’t be deleted if a user is still logged on to the database. This may prevent you from accessing that DB. Try deleting the .accdb/.ldb file and check if you can access the database.

You May Also Like  Why Custom Software Development is Important?

2. Import Objects to a New Database

By importing the objects from the corrupt database to a new database, you may be able to recover the damaged DB. To do so, follow these steps:

  1. Open a Blank desktop database (refer to Figure 1).
  2. Click External Data > Access.External Data Option Figure 7 – External Data Option
  3. From the Get External Data – Access Database window, click browse to select the corrupt db, and then click OK.Get External DataFigure 8 – Get External Data
  4. From the Import Objects dialog box, select the tab corresponding to the objects you want to restore. For example, click the ‘Forms’ tab to import forms from the source (corrupted) db into the new one.NOTE: To restore all the database objects, click the ‘Select All’ button.Import Objects WindowFigure 9 – Import Objects Window
  5. Click OK to finish importing the selected objects into the new database.

Conclusion

The ‘Compact and Repair’ utility is a default method that can be used to fix corrupted Microsoft Access Database. If you are using an Access database .mdb file, you can also try using the JETCOMP.exe to recover data from the damaged DB. Also, there are a few workarounds that may help recover the corrupt database files (as discussed in this post).

But, if you fear losing crucial database files, use an Access database repair software such as Stellar Repair for Access to fix the corrupt Access database (.ACCDB/.MDB) files and recover all the DB objects.If you`re facing same issue on Microsoft Access Cloud Database then it is recommended to get in touch with your Hosted Virtual Desktop provider for more help.

Previous Post

How to Improve Your Business Communication Skills - 11 Tips & Strategies

Next Post

Major Tech Trends You Need to Watch Out for in 2021

Next Post
Major Tech Trends You Need to Watch Out for in 2021

Major Tech Trends You Need to Watch Out for in 2021

btc

FOMO Versus HODL: What Drives Investors to Invest in Bitcoins?

Leave a Reply Cancel reply

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

Write for us

write for us technology

About

Techdee is all in one business and technology blog. We provide latest and authentic news related to tech, marketing, gaming, business, and etc

Site Navigation

  • Home
  • Contact Us
  • Write for us
  • Terms and Condition
  • About Us
  • Privacy Policy

Google News

Google News

Search

No Result
View All Result
  • Technoroll
  • Contact

© 2021 Techdee - Business and Technology Blog.

No Result
View All Result
  • Home
  • Business
  • Tech
  • Internet
  • Gaming
  • AI
    • Data Science
    • Machine Learning
  • Crypto
  • Digital Marketing
  • Contact Us

© 2021 Techdee - Business and Technology Blog.

Login to your account below

Forgotten Password?

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.