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
“Jet has stopped the process because you and another
user attempted to change the same data at the same time”
4. If using Jetcomp to compact the database, the following error
”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.
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
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
6. You might want to test the table after each copy & paste
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