Cannot open any more databases error

  • Thread starter Thread starter TC
  • Start date Start date
T

TC

The message usually refers to tables (or equivalent internal things) - not
databases, AFAIK.

Note that you don't need DISTINCT >and< GROUP BY there. Drop the GROUP BY.
Perhaps some of the other queries are simialrly, unnecesarily complicated?

HTH,
TC
 
I have created a form in Access 2000/2002. The form
consists of many "combo-box" fields in which the rowsource
for an example field is:

"SELECT distinct [Plans].[Plan Consultant] FROM Plans
GROUP BY [Plans].[Plan Consultant] ORDER BY [Plans].[Plan
Consultant];"

The underlying query ("Plans") is a very complex query.
After "clicking" the "drop-down" on just a few fields, I
receive the error "Cannot open any more databases". I
have found that deleting the rowsource property for many
of the fields on the form, that selecting data for more
fields is possible, but inevitably, the error appears.

Is there a way to increase whatever the "maximum open
database" parameter might be? Is this error actually
referring to databases or to tables? Is there a solution
that anyone knows of to resolve this problem?

Thank you.
 
Back
Top