[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 517
  • Last Modified:

The Search Key was not found in any record

In Access 2007 I run query on a linked DB table (about 120mb in size) and a message box tells me "The search Key was not found in any record". The search I apply is on the year 2011, I know it is there in the table.
What could be wrong?
0
sebastiano72
Asked:
sebastiano72
2 Solutions
 
jerseysamCommented:
Remove any prefixed space characters. Sounds like 1st character was entered as a space by mistake, so it cant find the value
0
 
mbizupCommented:
*Possibly* data corruption.

Make a backup and try Compact/Reparing the back-end.
0
 
sebastiano72Author Commented:
SELECT MOVMAG.ANNREG, *
FROM MOVMAG
WHERE (((MOVMAG.ANNREG)="2011"));
Database1.docx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
This error almost *always* means that one or more fields in one or more records are corrupted. Usually ( as suggested above), a Compact and Repair will fix this, but not always.  Be SURE you make a backup first.

If this does not work, then I highly recommend the following repair service:

http://www.everythingaccess.com/accessdatabaserepair.htm

mx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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