Error messages generally

[Jack Sheet]

If this message appears twice, then my heartfelt apologies. A few days ago
I posted a message that I know never appeared, and I have since posted the
one below that does not appear on my newsreader after several hours, so it
may have gone the same way.

I am interested to know:
If I have a select query Q1 based on a table
and a select query Q2 based on Q1
and a select query Q3 based on Q2
and perhaps so on for several levels,

should I EXPECT after just a few iterations to run out of computer
resources, and so perhaps give rise to the error message "MicroSoft Office
Access has encountered a problem and needs to close"?

In other words, do I need to be particularly careful about available
resources when creating such a string of queries? Assume that I am NOT
bothered about consumption of disk space and I am NOT bothered about the
amount of time it takes to run the query.

 

[Guest]

I have seen this happen when there was a syntax problem in one of the queries
that could not be resolved. Nesting queries is not the problem, it is there
is an error in one of the queries. Try starting with Q1, if it runs, then
run Q2, etc.