[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