Search key not found

[ArkRoyal]

Data which was stored in a Filemaker Pro database, has been sent to me in an
Excel worksheet format. I have now imported the data into my Access 2007
Database with no apparent problems, other than one of the records has
information that is irrelevant. I've tried to delete the record, however, I
get the error message "Search Key not found.", and the record won't delete.

Can anybody throw some light on the problem, and provide me with an answer.

 

[gllincoln]

Hi ArkRoyal,

Sounds as if that record might be corrupted? I would run compact & repair as
a standard operating procedure. If that solves the problem great - but it
usually doesn't. So the second step would be to copy the table to a new name
and see if the new copy has the same problem. If it does, then I would run a
make table query using criteria that would select everything except the
flaky record. If that gets everything except the bad record, then recreate
(if possible) the bad record, kill the old tables and you're on your way.

Hope this helps,
Gordon

 

[Jeanette Cunningham]

ArkRoyal,
does this help? Some errors that are fixed by installing the hotfix for
A2003 SP3
You create and then save an .adp file in Microsoft Visual SourceSafe
(VSS) in Microsoft Office Access 2003 Service Pack 2 (SP2). When you try to
check out a form, you receive one or more error messages that resemble the
following error messages:
Error message 3
The search key was not found in any record.

this is the page
http://support.microsoft.com/kb/945674

Jeanette Cunningham