Q247771 ACC2000: How to Recover Data from a Damaged (Corrupted) Table.

Summary

How to repair a corrupted database when it is not possible to recover it by the following methods:
For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 209137 (http://support.microsoft.com/kb/209137/) How to troubleshoot and repair a damaged Jet 4.0 database

This problem will occur when any of the following actions are attempted:

1. Run a query,report or form
2. Update any records
3. Scroll through data in a damaged table.

When this occurs you may have received either of the following errors:

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

“#Error “

4. If using Jetcomp to compact the database, the following error may appear:

”Records can't be read, no read permissions on MyDatabase”

5. If the MyDatabase placeholder is the name of your database you will be able to open and view the data within a table, but it cannot be exported or imported externally to another database.

More Info

Copy the database to avoid the possibility of creating further irreparable damage in the process of repair.

If you want to recover data from a damaged table:

1. Copy the table.
2. Paste the structure of the damaged database table to a new one.
3. Open table and the copy you made of the table structure in order to see both tables.
4. On the damaged table, select ‘Datasheet View’, then select the entire record by clicking on the blank buttons to the left of each record. Now, copy the records from the damaged database table.
5. After switching to the new table, line up the pointer in the same location as it was in the damaged database table. Now, click Paste.
6. You might want to test the table after each copy & paste process.
7. Repeat the first 4 to 6 using single records or smaller groups records. Eventually you will get an error when testing the corrupted records. Replace any data that can’t be moved into the new table by retyping it.
8. When all records have been moved into the new table, create a new database with a different name to the damaged one.
9. Now import the table and all of the undamaged objects into the new database. After you have imported the table, exit the program.
10. Rename the corrupt database or move to a new location. Remove the .ldb file for the damaged database (if one is present) then move the new database to a new location.
11. Now, rename the repaired database with the damaged database name.