System Resources Exceeded

  • Thread starter Thread starter Artie Weiner
  • Start date Start date
A

Artie Weiner

I have a query made up of 4 queries, each of which are 2
and 3 queries deep. I'm getting the message "System
Resources Exceeded" on all machines trying to run the query
or report.

Any suggestions or ideas on what causes this problem? I
don't know that it's related to the depth of the queries,
but I'm guessing so.

Thanks very much,

Artie
 
Hi,


You may have a join that produces an excessive amount of records such
that the intermediate result exceed the limit of Access (2Gig, for Access
2000 and more recent).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top