S
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. in criterion for Date I enter >=#1/1/2005#) then I get
the above error message.
This did not happen with Access 97.
Also, if I run the same query on a smaller db4 table, about 61,000 records,
then it runs OK.
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. in criterion for Date I enter >=#1/1/2005#) then I get
the above error message.
This did not happen with Access 97.
Also, if I run the same query on a smaller db4 table, about 61,000 records,
then it runs OK.