system resource exceeded

O

ody

Hi guys, please help me with this.. when I run my query
for 5 hours, it always gives me an error message in the
end " system resource exceeded"
How will I be able to solve this?
 
V

Van T. Dinh

5 hours???

I have some exceedingly large Tables ( > 1 million Records) and can't recall
any Queries that take more than few minutes to process.

I would suggest if you call some functions in your Query, check for infinite
loops.

Perhaps you should post relevant details of your Tables and the SQL String
of your Query.
 

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

system resource exceeded 4
System Resource Exceeded 3
System Resource exceeded 2
System Resource Exceeded 2
System Resources Exceeded 1
Too comples Query - (I cant use VBA) or system resource exceeded 1
"System Resource Exceeded" - message when running query 3
System Resource Exceeded 6

Top