[AccessD] Corrupted Record

Rocky Smolin rockysmolin2 at gmail.com
Tue Dec 5 23:29:34 CST 2023


Dear List:
I have a client who added a record to a table and that record is corrupted
(there are Chinese characters in it). You can't do anything with it. If I
try to delete the record I get the message "The search key was not found in
any record.

I remember having this problem before and found a way to get it out.  The
important thing is to preserve the PK because there are child records.

I tried making an empty copy of the table, removing the key. Then I removed
the key from the original table, and copied and pasted all the records
except the last, corrupted one.

That appeared to work but when I put the primary key back on the primary
key field, all of the PKs changed. It renumbered them starting with the
last record PK +1.

Anyone know how I got rid of this corrupted record and preserve the PKs?

MTIA

Rocky


More information about the AccessD mailing list