Search Key Not Found In Any Record

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

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?
 
Send me a copy of the file and I will try it.
Remove the nospam from my adress.
Click to expand...

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.
 
Bill said:
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.
Click to expand...

Just curious. Did you try compacting that MDB when it still had the
bad record?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Bill said:
No. Never thought of it.
Click to expand...

If you ever get a chance to do so on a backup of it which did have the
bad record I'd sure be curious to know the results.

Did that record have any memo fields? Could you tab from field to
field for every field on that record?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top