error message is "The Search Key Was Not Found In Any Record"..

[Victor Cheung]

sometime.. an runtime error 3709 pop up.. from anywhere in the program..
when it try to read/write to an access database? the error message is "The
Search Key Was Not Found In Any Record".. I don't have any more clue..
please help..

 

[Mary]

Did you try the knowledge base?

Link to

http://support.microsoft.com/default.aspx?scid=fh;en-
gb;kbhowto

If you haven't used it before: select product and version
and key in the error message number, if this doesn't help
just try the message, then number and message.

This will list situations in which the runtime error comes
up for real and also where it might occur spuriously.

Jean

 

[Allen Browne]

If this message appears in an inappropriate context, the database is
partially corrupt.

Try a repair (Database Utilities on the Tools menu).

 

[Victor Cheung]

did repair and still got crap.. I knew it is the access database.. but..
just can't repair it..

didn't expect access database to die like that..

upgraded from access 2000 to access 2002.. don't know if it makes any
different.. any better access database repair tool?

 

[Allen Browne]

Try creating a new (blank) Access database.
Immediately turn off Name AutoCorrect (Tools | Options | General).
Then import everything from the old database (File | Get External | Import).

Recreating everything like that may solve the issue.