Search Key Not Found

[Robjenj]

Hi guys! I'm maintaining an Access database application pro bono for a busy wildlife hospital on Australia's Gold Coast. The db now has close on 24k records. It is serviced on a linked file system running on 7 different client instances. They need to delete a problem record, but find they cannot do so because the system returns "Search Key Not Found", and clicking the OK button leaves the record in place. Exactly the same thing happens if I try to change any field in the record. The search key field is the primary key field with an AutoNumber field type. There are no apparent data inconsistencies in this record. Is there a kind knowledgeable person who could suggest a means of getting rid of this record? It is clogging up the hospital's Waiting List!

 

[namliam]

Have you tried to do a "Compact and Repair" of the database?

 

[IndigoStickman]

I trust that you've already tried opening the table that contains the offending record in datasheet view and simply tried to delete the row altogether?

Its a rather primitive and slightly raw way of doing it (I'd prefer to do it through the front end via a process but when needs must...), but I've been forced to do it that way on occasion, but haven't seen the same error message as you have before.