ERROR MESSAGE (system resource exceeded)

M

mezzanine1974

I have a serial linked query. I mean, each query is calling another
one sequentialy. So it is quite complicated and after 5th query, i got
an error message like that (system resource exceeded).
Actually 5th query running well, but this error message occurs when i
attemp to put a criteria for a column in the 5th query. I have already
tried several combination to simplify the query but no hope.
So, I think, I may have a chance to create a tabular form bounded to
5th query. Then, it may be possible to write some codes on the form
events, so that i can list the query result under criteria what i
need.
Do you have an idea?
 

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
System resource exceeded 3
system resource exceeds 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
use error handling to assign value 5
Keep cell position in a formula after data is deleted 2
System Resource Exceeded 2
how do i resolve the 'system resource exceeded' error? 6

Top