ERROR: Cannot open any more databases

Posted on 2006-06-04
Last Modified: 2008-02-01
I have a few nested subforms in a datasheet view form in MS Access 2000.  Anytime I try to scroll (mouse or scrollbar), or expand or collapse any nested table, I get a " ERROR: Cannot open any more databases", and the error will repeat 10-20 times, sometimes giving me a bunch of error boxes all over the screen.  

Please help!
Question by:cdmac2
    LVL 58

    Accepted Solution

    Hello cdmac2

    What is "a few"? For datasheet view, one would be ok, perhaps two if you really like this sort of things, but not more than that.

    You should understand that each expanded view is a new object, displaying a new query. As it stands, Access has the strange habit of opening  a new Database object for each of these. If you have too many open, you get the "no more databases" message, which should read "too many queries".

    Do you have any code behind these nested subforms? Without any code, Access will just goes into infinite refresh loops and stops responding (I tried with six levels). If you have code behind the forms, the class module will have to be instanciated once for each expanded view, which could explain the error.

    LVL 27

    Assisted Solution

    This sounds like a broken Reference,
    in VBA look at Tools/References,
    and look for the selected checkbox with the word MISSING,
    unselect them.

    LVL 1

    Author Comment

    Hey again Harfang,

    This is actually an issue relating to my last question:

    I've now scrapped the idea of the nested datasheet subforms (a "few" = 3 by the way), and I'm using an embedded Excel sheet to accomplish what I need... I'm sure I'll end up having a question or two on the Embedded Excel sheet, but I think i'm off to a good start...

    I"m going to give 100 points to jjaffer for his thoughts.

    Thanks for your help!
    LVL 58

    Expert Comment

    I don't know where the error is coming  from, in that case. Unless you have some heavy coding behind these forms, as I said. I don't think the Excel sheet is going to last. It introduces too much freedom for good data integrity.

    Anyway, success with your application!

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now