Cannot Open Any More Databases

[Guest]

I get the message "Cannot Open Any More Databases". This problem is not
related to setting objects and not closing them and setting them to Nothing.
Does any one know the cause and solution to this problem?

Thanks!

 

[Allen Browne]

What version of Access? If 97, check that you have Service Pack 2 installed.
(It doubled the number of available databases before this error is
triggered.)

When does this occur?
When running code?
With a form that has lots of subforms and combos or list boxes?
With a query that uses domain aggregate expressions such as DLookup()?

 

[Guest]

Thanks again, Allen!

I am using AccessXP in 2000 mode. I have a form with lots of subforms. The
form contains a matrix of textboxes where each has a different value. I have
the same subform linked to each textbox with Linkmaster and Linkchild
appropriately set. The rowsource of the subform is a query based on six
tables.

My database is split. I have found that if I create a single database that
includes the tables, I do not get the error message. When the database is
split, I have also noted that only some of the subforms get populated.

Thanks!

 

[Allen Browne]

Each form uses a "database" connection, and its RecordsetClone uses another
if you are using those, so "lots" of subforms is a factor. Unless you have
dozens of subforms, there must be something else here as well.

The RowSource for every combo or list box also uses a "database" connection.

The domain aggregate functions such as DCount() or DMax() also use a
"database" connection, so perhaps you have lots of text boxes using these,
or perhaps the query itself contains a domain aggregate function that Access
execute for every row in the query?

 

['69 Camaro]

Hello, Steve Santus.

Don't tell me: Melissa is your middle name, and PC Datasheet is your maiden
name. ;-) But I don't understand why you'd post questions deceptively
under another moniker when you need help, instead of using a name that
people here already know you by. There's no limit to the number of
questions you may ask, if that's what you're thinking. Many people have
asked hundreds of questions in the newsgroups and most, if not all, of their
questions in the Access newsgroups have received good advice. You've
received many good answers from experts when you've posted under your real
name, so you can't say that people won't answer your questions unless you're
wearing a skirt.

Personally, I don't care what you wear when you're working on the computer
in your own office, but a skirt's rather breezy, dontcha think?

Gunny