Solved

"search key was not found in any record"

Posted on 2001-06-15
4
184 Views
Last Modified: 2010-05-02
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
Comment
Question by:pakmara
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6196271
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
 
LVL 2

Expert Comment

by:chandukb
ID: 6196275
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
 
LVL 49

Expert Comment

by:DanRollins
ID: 7136185
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 7173390
Question placed in PAQ

Computer101
E-E Moderator
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question