System Resource exceeded

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
 
M

[MVP] S. Clark

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

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

Top