Solved

Cannont open any more databases

Posted on 2014-04-24
3
254 Views
Last Modified: 2014-04-24
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
0
Comment
Question by:cansevin
3 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 40020767
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
 

Author Closing Comment

by:cansevin
ID: 40020929
Thanks, I am going to try to condense.
0
 
LVL 57
ID: 40020940
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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now