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

[Simon Monk]

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?

 

[KARL DEWEY]

Criteria of a query would not be in the syntax that you wrote but like --
FIELD: YourDate Field
CRITERIA: >=#1/1/2005#

 

[Simon Monk]

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.

 

[Simon Monk]

One more piece of info: If I run the same query on a smaller db4 table,
about 61,000 records, then it runs OK.