Forum Discussion
Cannot Open any more databases
This message often occurs when Access has used up all available connections.
See my utility Available Connections which you can use to check the issue and from that work out what needs to be changed to solve your issues
Hi, I downloaded your utility and tried it out. Works great by the way! The issue I hope you can help me with is I'm losing 2 connections every 10 seconds with your form being the only thing open in the database. Is that normal? Or should I only be losing connections if I have an object, or objects, open that are linked to data in the tables? If I open your Available Connections database and open the form, it doesn't lose connections every 10 seconds. Only my databases are doing this (I've tried it out on a few other of my DB's). I'm nowhere close to an expert but I've used Access quite a bit over the years and I've never encountered this issue. I've checked and double checked that I'm not leaving any recordsets open (which I'm not - there's only a few instances in my code where I am opening a recordset and I close it and set it to Nothing each time) and I've tried compact and repair. Also, every time I close Access, the Record Locking Information icon stays... open? Not sure how to word it but I can't open Access back up until I open Task Manager and End Process. My form doesn't have any controls on it that are linked to any data in the database. The form has one button that runs code and when it runs, the connections drop by about 200 to 250 and when i close the form, the connections don't come back and they'll continue dropping by 2 every 10 seconds. Thanks in advance for any help you can offer! isladogs
- Sep 09, 2024
Hi,
You didn't mention your version and build number of Office. Therefore, one can only assume that the lost connections are being sucked up by a current Office/VBA bug. You can find details and the information about the planned fix in our documenting AFo article.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg- Sep 10, 2024
Hi,
Version 2408 build 17928.20156 with the fix for this new bug in Aug/Sep 2024 is now available in the Current Channel. You may have to select Update now in File - Account to get it immediately. Details can be found in our documenting article on AFo.
Servus
Karl
Access Forever News DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg- Mm165516Sep 10, 2024Copper Contributor