Search Key Not Found Error

[himeshhi]

Hi all,

Search Key not found in any record message is displayed when trying to delete a record from an MS Access table which for some reason turned into strange characters and chinese text. I cannot copy and paste the records into another table as one of the columns is auto number and within the table there are gaps which mean the autonumber will not remain the same in records on the previous table. This is most important that they stay the same. All I want ot do is to delete the corrupt record however access won't allow...

[NeoPa]

Unfortunately, you seem to have misunderstood the usage of an AutoNumber field. If it's important that the value stays the same, then it should not have been set up as one. The whole concept of an AutoNumber field is foreign to that idea.
As far as the rest goes, I'd recommend setting up an APPEND query to copy your data across. Alternatively, you could try a Copy/Paste of the table to a new one (after deleting the problem record) and seeing if that maintains the AutoNumber field even.

Good luck and Welcome to TheScripts :)