System Resource exceeded

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

Dear Gurus:

I am writing a query that will have ten column, each
succeed column refers to the previous calculated column.
It is running OK until the last one, and I get error msg
called " System resource exceeded".

What's causeing that and is there any way to deal with it?

Thanks in advance,

Jackie
 
If there are 9 columns calculating each time, it may be too labor intensive
for Access or the machine.

Try breaking the query into two or more steps and see if the problem goes
away.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top