Search Key not found in any record

Search Key not found in any record

Post by Bill » Sat, 29 May 2004 09:15:23

My import blows up with the totally unhelpful message "Search Key Not
Found In Any Record." After many hours of testing, reading and
Internet searching, it seems this message has all kinds of causes
(none of which help me).

Apparently Microsoft has been letting lazy programmers dump out with
this meaningles error message for years and years, release after
release. That really ticks me off. The programmer knows why his code
detected an error. At the very least they could at least give you a
record number.

I've written a C program to scan my file and validate each and every
field with no errors found. Every record is all text, tab delimited,
in quotes, no null fields, no missing tabs, no leading blanks. I'm up
against a stone wall.

What can I do next?

Search Key not found in any record

Post by Joe Fallo » Sat, 29 May 2004 13:06:48

Send me a copy of the file and I will try it.
Remove the nospam from my adress.
Joe Fallon
Access MVP


Search Key not found in any record

Post by Bill » Sun, 30 May 2004 02:28:19

On Fri, 28 May 2004 00:06:48 -0400, "Joe Fallon"

Thanks but I fixed it.

I kept cutting the file in half (2,000,000 records to start with)
until I isolated the "bad record." There was absolutely nothing wrong
with it - no special characters or anything different from any other
record but taking it out fixed the problem. I added the same record
back in manually and it was fine.

I'd still like to know why Microsoft feels they don't have to provide
an error description or even a record number in this case. It's not a
bug because I've found postings about this cryptic message going back
years. Clearly, Microsoft decided in release after release not to
provide a clear error report in this area.

It cost me a day and it ticks me off.

Search Key not found in any record

Post by Bill » Tue, 01 Jun 2004 03:19:23

On Sat, 29 May 2004 22:31:58 -0600, Tony Toews

No. Never thought of it.

Search Key not found in any record

Post by RCBIdWJlc » Sat, 05 Aug 2006 03:33:02

Every month for the last 6 months I import a text file into access with no
problems. Suddenly this month when I tried to import the most recent data I
get the message "The search key was not found in any record." Why have I
never seen this message before and is there a way to get around it? Thanks
for any help in advance.