Cannont open any more databases

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.


Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
you might have reach the limit of the number of queries you can open.

see this link for the specification
cansevinAuthor Commented:
Thanks, I am going to try to condense.
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.

All Courses

From novice to tech pro — start learning today.