System Resources Exceeded

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
 
M

Michel Walsh

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
 

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

Anyone going to answer my post 1
system resource exceeded 4
'system resource exceeded' and 'query too complex' 4
Run time Error 3035, System resource exceeded 6
System Resource Exceeded 2
Query is too complex 5
"System Resource Exceeded" - message when running query 3
"Maximum Number of fonts exceeded" 2

Top