The Search Key was not found in any record

Posted on 2011-10-13
Last Modified: 2012-05-12
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?
Question by:sebastiano72
    LVL 15

    Expert Comment

    Remove any prefixed space characters. Sounds like 1st character was entered as a space by mistake, so it cant find the value
    LVL 61

    Accepted Solution

    *Possibly* data corruption.

    Make a backup and try Compact/Reparing the back-end.

    Author Comment

    WHERE (((MOVMAG.ANNREG)="2011"));
    LVL 75

    Assisted Solution

    by:DatabaseMX (Joe Anderson - Access MVP)
    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:


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    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…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now