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.

Thanks!

Chris
cansevinAsked:
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

http://office.microsoft.com/en-us/access-help/access-specifications-HP005186808.aspx
0
 
cansevinAuthor Commented:
Thanks, I am going to try to condense.
0
 
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.

Jim.
0
All Courses

From novice to tech pro — start learning today.