Runtime error 3048: "Cannot open any more databases"

Question

Hello,

Somebody please help!

This runtime error detailed below is trying to mar my effort on a database that have taken me a long time to create.

The error is: "Runtime Error: 3048: Cannot open any more databases"

It often comes up anytime I try to open a form that has 10 subforms. About 6 out of the subforms have their underlying forms connected to one query. "Sales Invoice Totals" which I created with 6 talbes.

Moreover, when I click the debug button, it irregularly points to any line in any code that in my own little knowledge I see nothing wrong.

Any Idea of the solution will be appreciated.

Thank you all

Answer 1

Sounds like you've hit the limits of Access.

You see when you insert/use various controls in your db they require database connection(s) and by the sounds of it, your form is extremely complexe and you hit the limit of what is possible.

You need to take a step back and see how you can break up your form so as to not have so many connections.  Perhaps dynamically loading subforms, removing some altogether and creating pop-up forms, ..., but a redesign is in order.

Good luck.

Answer 2

Hello,

I have searched a lot for this error and all seems to point to the many connections to the back-end database.

Now, I have a form that bound to a table in the back end that I derive some values from for use in the front end from it's combo box. It remains open and invisible from the time I open  the database to the time I close it.

I need to create a kind of temp table that I can use to store those values so that I can always close the form after signing in to reduce the amount of connection to the back end.

Please, I need your ideas and suggestions on how I can create this temp table with code and possibly delete it when I close the database.

Thanks for all your assistance

Answer 3

Thanks a lot for your reply.

Please, can you help me with say the basics to restructure or make a good and standard database design.

Proir to my post, I had checked the relationships to ensure that the tables participate in   Relationships.

Answer 4

If you search online for this error message you'll get a lot of good suggestions.

Basically this does not (as easily) happen on a very well designed database. Improve the overall quality, including quality of database design and code, as well as application design.