"search key was not found in any record"

In attempting to update records in a table from VB5 to Access 2000, I get a

"search key was not found in any record"

error that crashes the app.

Any idea what this means?
pakmaraAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Computer101Connect With a Mentor Commented:
Question placed in PAQ

Computer101
E-E Moderator
0
 
DRRYAN3Commented:
See http://support.microsoft.com/support/kb/articles/q245/4/08.asp for details on complex finds in ADO.  

Also, if you are updating a table make sure that your primary key is in your recordset.
0
 
chandukbCommented:
This may be because of corrupted database.  save a copy of your database on the server, then open the file in Access and run a compact and repair.

Chandu
0
 
DanRollinsCommented:
Hi pakmara@devx,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:

    Save as PAQ -- No Refund.
*** no way to know if either comment solved the problem

EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.