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

-----Original Message-----
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..
.

[Allen Browne]

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

Try a repair (Database Utilities on the Tools menu).
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Post by 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.

[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?

Post by Allen Browne
If this message appears in an inappropriate context, the database is
partially corrupt.
Try a repair (Database Utilities on the Tools menu).
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Post by 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.

[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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Post by 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?

Post by Allen Browne
If this message appears in an inappropriate context, the database is
partially corrupt.
Try a repair (Database Utilities on the Tools menu).
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Post by 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

Post by Allen Browne

Post by Victor Cheung
Search Key Was Not Found In Any Record".. I don't have any more clue..
please help.