Not Enough Resorces to Run Report

  • Thread starter Thread starter Tedd
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

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

Report Query Works 2nd Time, But Not 1st 14
Running Report error 1
Combining Data From Linked Excel Tables 5
Running reports in a multiuser VB/Access environment 0
Not enough space on temporary disk error 13
Access Access Report Works on One Machine but not Another 3
Unique values divide by zero error 1
Running Report from Query using Open Form or Entering Criteria 1

Back
Top