Not Enough Resorces to Run Report

T

Tedd

I am running a large query (getting data from 30+
different small queries). The query itself runs fine.
However, when I try to run a report based on the query it
tells me that I don't have enough resorces to run it.

Has anyone seen this before?
 
W

Wayne Morgan

I'm guessing, is this a Win9x computer? Having a query run from 30+ queries
is going to use a lot of resources, it may simply be that adding the report
to the mix is too much. Try an NT (NT4, Win2k, WinXP) computer if you have
one available to see if it will work there. If this doesn't help, you may
want to see if you can combine some of those queries into fewer queries, but
not as UNION queries.
 
Top