Recovering data from a damaged database table or a corrupted database table in Access 2000, 2002 or 2003

Read time 3 min

Sometimes when you try to run a query, a report, or a form, update records or scroll through data in a damaged Access database table, you receive following error messages:

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

When you use Jetcomp.exe to compact a database, you may receive the following error message:

Records can’t be read, no read permissions on MyDatabase

When any of the above mentioned error message appears, your next step should be towards recovering data from database tables.  In such a situation, you can open a database table, view its data but cannot export or import that table from or to any other database.

Solution: For dealing with this issue, you will need to recover data from the database table. But before starting the recovery process, create a backup copy of the database, so that irrecoverable damages can be avoided. To recover data from damaged database table, follow these steps:

1. Make a copy of the damaged database table.
2. Re-create or paste the structure only of the damaged database table to a new table.
3. Open the damaged database table and the copy of the table structure so that you can see both tables.
4. Switch to the damaged database table. On the View menu, click Datasheet View, and then select the whole record by clicking the record selectors that are the blank buttons to the left of each record. On the Edit menu, click Copy to copy the records from the damaged database table.
5. Switch to the new table, put the pointer in a location that will put the data in the same location that the data was located in the damaged database table. On the Edit menu, click Paste.
6. Test the table after each copy-and-paste operation.
7. Repeat steps 4 through 6 by using single records or small groups of records until you receive an error message while testing only the corrupted records that remain. Then, re-type any data that cannot be moved to the new table.
8. After all records have been moved to the new table, create a new blank database in Access with a different name than the damaged database.
9. Import the new table and all undamaged objects to the new database, and then quit Access.
10. Rename the damaged database or move the damaged database to a new location. Delete the .ldb file for the corrupted database if the .ldb file exists, and then move the new database to the location that you want.
11. Rename the repaired database to the name of the damaged database.

With the help of above mentioned steps, you can recover table data from a damaged or corrupt Access database and can recreate the database with it. Once the database is repaired, you need to test it before returning to the production environment. A  MS Access recovery software helps to rebuild corrupt MDB databases to working databases. Kernel for Access Database Repair software is available for evaluation purposes which further help to know the features and functions of the software.