How to remove/repair 2 corrupted records?

[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

 

[John Vinson]

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

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]

 

[Devouru]

Thankx for the reply. After several attempts, I was able to copy the back
end, compact/repair, and delete the bad records.

-JS