[AccessD] Corrupted Record

[Rocky Smolin]

Jim:

Having removed the index and the primary key I still cannot delete the
record. I get the message "The search key was not found in any record". :o(

Anything else you can think of that I could try?

Thanks

Rocky


On Wed, Dec 6, 2023 at 6:13 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

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