"The search key was not found in any record."

[NC1HOWDY]

This problem won't go away. I've tried everything I know to get rid of this msg. The last record listed has ASCII type symbols in which look like boxes in many of the fields, and when I try to delete the record, that is when i get the msg. I've turned off the Pri key and tried to delete the record, no success. I've even added a new primary key in an attempt to allow record deletion. Anyone with experience pls advise. Thanks. NC1

 

[Liv Manto]

Have you tried compact and repair?

I think thats a corrupt table. REcheck your code or table set up.

(Ken Higgs was asking how many records.)

IF you cant fix it, copy the structure to a fresh table

then create an append query.

If the corrupted data is number 23,

append 1 to 22.

then delete 1 to 24 from the corrupted table ( please make sure you make a copy first before deleting so you could copy number 24 later)

then append the remaining.
IF the the number is autonumber or record id, then do not include that in the append query, let it create its own recid.

The idea is skip the corrupted record.

Of course I am not sure if this your problem. This is just in case you've run out of ideas.




If you cant do the above instructions, send it to me.

 

[NC1HOWDY]

Liv Manto's Advice Worked

Thanks.
I wasn't aware of the compact and repair solution, I will read more. I was able to delete the fouled record after the compact and repair. I hope any future problems are just as easy! Thanks for your inputs/help. NC1HOWDY