[AccessD] Corrupted Record

[Jim Dettman]

Drop the indexes on the table, then try deleting the record.  Re-add the
indexes afterward.

Try this on a copy of the table first (just right click on the table in the
DBC, copy, then right click in the container and select paste).

Jim.

-----Original Message-----
From: AccessD On Behalf Of Rocky Smolin
Sent: Wednesday, December 6, 2023 12:30 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: [AccessD] Corrupted Record

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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com