[AccessD] Corrupted Record

[Rocky Smolin]

Jim and Borg:

You're not going to believe this, but I did a compact and repair on the
database and then I was able to delete the record. I feel a little stupid.
That should have been the first thing to try.

Thanks for the input, though. It kept me at it until I stumbled on the fix.

Best,

r




On Wed, Dec 6, 2023 at 6:49 AM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> 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
>>
>