<div>
Thanks, I am going to try to condense.
</div>


<div>
Try shortening the table names by aliasing them. &nbsp;That may get you by.<br />
<br />
Access has an internal limit of 2048 table references. &nbsp;The limit floats a bit and sometimes you can eek out a little more.<br />
<br />
Jim.
</div>


Try shortening the table names by aliasing them.  That may get you by.

Access has an internal limit of 2048 table references.  The limit floats a bit and sometimes you can eek out a little more.

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 />
Any idea what causes this? This particular query is connected to a large number of smaller queries. The other queries are opening with out any problem. <br />
<br />
Thanks!<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.

Any idea what causes this? This particular query is connected to a large number of smaller queries. The other queries are opening with out any problem. 

Thanks!

Chris

Cannont open any more databases

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.