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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Anyone going to answer my post 1
System resource exceeded 3
system resource exceeds 1
Report Group Footer DLookUp 0
System Resource Exceeded 2
Converting URLs in comments to Markdown-formatted links 2
'system resource exceeded' and 'query too complex' 4

Top