<div>
and BTW, in general, you should avoid building query on top &nbsp;of query on top of query. &nbsp; Really you should only nest one level deep.<br />
<br />
Jim.
</div>


and BTW, in general, you should avoid building query on top  of query on top of query.   Really you should only nest one level deep.

Jim.

<div>
<div class="content wysiwyg-content">
I am trying to open a query and a warning pops up that stats &quot;Cannot open any more databases&quot;. Then I can click OK or HELP.<br />
<br />
From a previous question, I understand this is due to a limit that Access has built in. Is this limit just specific to the one query I am trying to run? This particular query is attached to 5 other queries. Does this limit trickle down to all the queries build on top of each other? Those 5 queries are build upon many other queries.<br />
<br />
I am trying to figure out where to fix the problem. Do I go to the bottom, and address the many queries in the background. Or do I stay on the &quot;top&quot; and just adress this query relating to the 5 sub queries. <br />
<br />
I really hope my question makes sense, but I doubt it!<br />
<br />
Any info you can provide would be helpful. <br />
<br />
Chris
</div>
</div>


I am trying to open a query and a warning pops up that stats "Cannot open any more databases". Then I can click OK or HELP.

From a previous question, I understand this is due to a limit that Access has built in. Is this limit just specific to the one query I am trying to run? This particular query is attached to 5 other queries. Does this limit trickle down to all the queries build on top of each other? Those 5 queries are build upon many other queries.

I am trying to figure out where to fix the problem. Do I go to the bottom, and address the many queries in the background. Or do I stay on the "top" and just adress this query relating to the 5 sub queries. 

I really hope my question makes sense, but I doubt it!

Any info you can provide would be helpful. 

Chris

Warning in Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.