[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Warning in Access

Posted on 2014-04-24
2
Medium Priority
?
208 Views
Last Modified: 2014-04-25
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
0
Comment
Question by:cansevin
  • 2
2 Comments
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 40021423
Chris,

 The limit applies to everything Access is doing at the moment.

  Five sub queries is a lot....maybe show us what your trying to do and what your tables look like and we might be able to optimize it.

Jim.
0
 
LVL 59
ID: 40021427
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.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

591 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