• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

"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?
0
pakmara
Asked:
pakmara
1 Solution
 
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
 
Computer101Commented:
Question placed in PAQ

Computer101
E-E Moderator
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now