Access 2003 error: The search key was not found in any record.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003, linking to a db4 file.
The db4 file currently has about 198,000 records and is about 70Mb in size.

If I design a query that simply displays all records, it works fine.
However, if I try to do any processing, such as selecting records according
to a criterion (eg. Date>=#1/1/2005#) then I get the above error message.

This did not happen with Access 97.
What am I doing wrong?
 
Criteria of a query would not be in the syntax that you wrote but like --
FIELD: YourDate Field
CRITERIA: >=#1/1/2005#
 
I tried this. That is: in the criteria space for the DATE field I put in the
same syntax as your line. The same error resulted.
 
One more piece of info: If I run the same query on a smaller db4 table,
about 61,000 records, then it runs OK.
 
Back
Top