ERROR: Cannot open any more databases

Posted on 2006-06-04
Medium Priority
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
  • 2
LVL 58

Accepted Solution

harfang earned 1600 total points
ID: 16829507
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

jjafferr earned 400 total points
ID: 16829905
This sounds like a broken Reference,
in VBA look at Tools/References,
and look for the selected checkbox with the word MISSING,
unselect them.


Author Comment

ID: 16830156
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

ID: 16830252
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

850 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