Recover Data from a Damaged Database Table in Microsoft Access

Manisha Rawat Manisha Rawat Updated On - 27 Nov 2019

Microsoft Access is a database utility provided by Microsoft Corporation as a part of the Microsoft Office Suite. Because of its easy-to-use and self-descriptive interface, both home users and professionals take its advantage as a backend to store data. However, sometimes while executing a query or a report or updating records, you may encounter the following error message:

“Jet has stopped the process because you and another user attempted to change the same data at the same time.”

Why Does It Happen?

Even when you are the only one using the database table, the preceding error message can be generated. This is because the database table might have been damaged due to which the Microsoft Jet database engine is unable to find the object. The database table can be damaged due to following reasons:

  • Abrupt system shut down when the database table is open
  • Improperly exiting MS Access
  • Malicious virus infection
  • Internal database errors
  • Problem in the storage media

How to Recover Corrupt Database Table in Microsoft Access?

Method 1:

When the database table gets damaged due to the situations mentioned above, and you receive Jet errors, perform the following steps to recover data from the damaged database table:

  1. Copy the damaged database table and save it to another location.
  2. Create the database table structure like the table structure of the damaged database table or copy the table structure of the damaged database table into a new database table.
  3. Open the damaged database table and its copy so that you can timely compare them.
  4. In the damaged database table, select View > Datasheet View.
  5. Now, select a record and copy it.
  6. Paste the selected record in a new database table at the same location where it was stored in the damaged database table.
  7. After pasting each record in the new database table, test it for accuracy.
  8. Repeat steps 5 to 7 until you stop receiving an error message while doing copy and paste of corrupted record.
  9. After pasting all the records into a new database table, create a new database in MS Access with some different name.
  10. Import the new database table and other well-working database objects into the newly created database.
  11. Rename the database table.
  12. Delete the .ldb file for a damaged database table, if exists.
  13. Now, rename the repaired database table to the damaged database table.
  14. Now, test the recovered database table to confirm its accuracy. Do not delete the damaged database table until you are not satisfied with the recovered database table.

Method 2:

Another way to recover a corrupt database table is that you use the Convert method. Consider the below mentioned steps for this method:

  1. Start with making a backup copy of the original database.
  2. In the Access 2000, go to the Tool menu, select Database Utilities and click on Convert Database. Finally, click on Access 2000 File Format.
  3. Next, you need to click on the database filename which you want to convert, end the process by clicking on Convert.
  4. The last step is to assign the new name to the file and click on Save.

Method 3:

Sadly, if you are out of options and still looking for effective ways to repair damaged database tables, then look no further. Kernel for Access Database Repair is one of the most advanced tools and is best-of-class in terms of price and Access database repair capabilities. It offers some of the most useful and advanced features which set it apart from its counterparts. Apart from recovering MDB and ACCDB files from severely corrupt databases, it can restore vital internal data structures and table structures with ease. It is also possible to recover deleted objects and records from damaged/ corrupt databases. The user interface allows even non-technical users to quickly and effectively use the tool without any assistance. One can also preview recovered data before saving in the desired location.

Let us now review the tool process, which is outlined below:

  1. The user will be prompted to browse for the corrupted Access database files for repair; once done, click on the Repair button.
  2. The initiates the repair process. The process might take a while as the filesize might vary. The progress bar shows the status of the repair process.
  3. Next, one can Preview and Save the recovered file to the desired location.
  4. After the successful recovery, the software will display the saving location.

Conclusion

Now we know that how important database table is, and there are manual and automated methods to recover it. But if you delete the damaged database table without testing it, and later you found that it is not properly responding, then you will not be able to recover data. Therefore, in case the recovered database table does not respond well, you can recover data from the damaged database table. However, this time to recover data, you need to take help of the automated method for sure.