Forum Discussion
Cannot Open any more databases
I have built an Access database that is throwing up error code 3048; "Cannot open any more databases". It has been doing it for a couple of years. I am using MS 365 on Win-10 Pro and it is all up to ...
That is a lot of connections for each form and you state you have multiple forms open at once.
No wonder you are having issues
Very few, if any of my forms are that resource hungry.
Most of my forms use 4 connections. A form with 12 combos uses just 2 connections
Even a very complex form with 11 subforms only uses 18 connections
I suggest you do a detailed review of your app and consider changing your approach
Even before the app crashes, performance will suffer as so many connections are in use
If you want to upload a copy of your db with all sensitive data removed, I may be able to make some specific suggestions that may help