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?
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:
- Copy the damaged database table and save it to another location.
- 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.
- Open the damaged database table and its copy so that you can timely compare them.
- In the damaged database table, select View > Datasheet View.
- Now, select a record and copy it.
- Paste the selected record in a new database table at the same location where it was stored in the damaged database table.
- After pasting each record in the new database table, test it for accuracy.
- Repeat steps 5 to 7 until you stop receiving an error message while doing copy and paste of corrupted record.
- After pasting all the records into a new database table, create a new database in MS Access with some different name.
- Import the new database table and other well-working database objects into the newly created database.
- Rename the database table.
- Delete the .ldb file for a damaged database table, if exists.
- Now, rename the repaired database table to the damaged database table.
- 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.
Another way to recover a corrupt database table is that you use the Convert method. Consider the below mentioned steps for this method:
- Start with making a backup copy of the original database.
- In the Access 2000, go to the Tool menu, select Database Utilities and click on Convert Database. Finally, click on Access 2000 File Format.
- Next, you need to click on the database filename which you want to convert, end the process by clicking on Convert.
- The last step is to assign the new name to the file and click on Save.
You can try the automated method by using Kernel for Access Database Repair. It is a database table repair and recovery software, which you can use to repair the damaged database table in just a few clicks. The software perfectly recovers all records from the damaged database table keeping the table structure intact. Kernel for Access can recover data from the database tables created in Access 2003, Access 2002, Access 2000, Access 97, and Access 95.
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.