Home > Access, Error messages > The search key was not found in any record in Access

The search key was not found in any record in Access

September 15th, 2009 Leave a comment Go to comments

Well, I got this error message today while I was trying to import a text file:

“The search key was not found in any record”

After some research, I found that either it was a bug caused by Microsoft Jet 4.0 Service Pack or it was the size of the database (should be not greater than 2GB). It turned out to be the later one. I fixed this problem by compacting and resizing the database. In Access 2007, you click on the Office Button (Top Left Corner), then Manage > Compact and Repair Database.

Share
[CiteULike] [del.icio.us] [Digg] [Facebook] [Furl] [Google] [Reddit] [Slashdot] [StumbleUpon] [Technorati] [Twitter] [Email] More »
Powered by Bookmarkify™
Categories: Access, Error messages Tags:
  1. Irene
    March 7th, 2010 at 07:37 | #1
    Reply | Quote

    For a year i have been wondering how to resolve this error until today after reading your blog.

    Thank you a million!

  2. a7n9
    March 8th, 2010 at 08:47 | #2
    Reply | Quote

    Irene, I am glad to hear that.

  3. Carla
    March 19th, 2010 at 10:39 | #3
    Reply | Quote

    thanks! this error has been a problem

  4. Sean
    June 25th, 2010 at 08:16 | #4
    Reply | Quote

    I got the same problem but it was not to do with the Jet SP. I had leading spaces in column headers which I removed and was able to import.

  5. clement
    July 5th, 2010 at 08:21 | #5
    Reply | Quote

    Thanks man. Sometimes these microsoft operation system and applications come very close to driving me insane. Your recommending works well. It would be good if Microsoft help was more interactive and usefull. I’ve lost a day or more with this problem. cheers for being a saviour

  6. a7n9
    July 6th, 2010 at 08:11 | #6
    Reply | Quote

    Not a problem, clement. I am glad that these solutions helped you.

  7. Val
    August 5th, 2010 at 09:42 | #7
    Reply | Quote

    For me is not working I try your suggestion still not working…
    Made all different attepmts not work….

  8. Adam
    August 23rd, 2010 at 15:16 | #8
    Reply | Quote

    Thanks, really helped.

    They should make the error message more useful, though. Something like “Hey, your database is too big.”

  1. No trackbacks yet.