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.