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

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?
 
G

Guest

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

Guest

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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The Search Key was not found in any record... 0
Problems Compacting Access in Office 2007 16
search key not found in any record 4
search key was not found in any record - isam seek error 3
Search key not found in any record 3
Access 2007 displays records in reverse order from Access 2003 3
"no current record" error in acces 2007 0
"the search key was not found in any record" 1

Top