How to remove/repair 2 corrupted records?

  • Thread starter Thread starter Devouru
  • Start date Start date
D

Devouru

I have a table that has a couple corrupted records. Repair/Compact does not
work, nor can I delete them. The problem is, auto number. How can I recover
the records AND retain the next autonumber in this table? TIA

-JS
 
I have a table that has a couple corrupted records. Repair/Compact does not
work, nor can I delete them. The problem is, auto number. How can I recover
the records AND retain the next autonumber in this table? TIA

-JS
Click to expand...

See

http://www.granite.ab.ca/access/corruptmdbs.htm

for salvage and repair instructions.

I'd suggest creating a new, empty database; create the table, empty;
and link to the existing table, and run an Append query to migrate all
the intact records. The damaged records must be reentered manually -
they're toast at this point!

John W. Vinson[MVP]
 
Thankx for the reply. After several attempts, I was able to copy the back
end, compact/repair, and delete the bad records.

-JS
 
Back
Top