Can Not Open Any More Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A database has a form with a complex recordsource. When one tries to open the
form, the message "Can not open any more databases" appears. The database is
a split AccessXP (2000 mode) database on a network.

What is the cause if this error message? Cure?

Thank you!!
 
Just a guess, but your code likely is opening multiple connections to a
database via CurrentDb function or DBEngine usages, and your code isn't
closing them and setting them to Nothing. At some point, ACCESS says "no
more".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
What are the steps to fix damaged MDF files in SQL Server? 0
Database keeps corrupting 22
Cannot open any more databases 6
question about resource consumption in the Jet database 2
Database Opening as Read Only 1
Opening a database via Citrix 7
Multiple users of a split database 3

Back
Top