Forum Discussion
Gordon Hertzman
Feb 03, 2022Copper Contributor
Error: Cannot open any more databases
Getting this error all of a sudden on FOUR different MS Access databases on four different computers. On one computer I uninstalled Windows updates and did an Office repair. Is there any information about this.
I can safely say that it is not related to file locking or open and closing recordsets. No changes were made to the system that I got the error to go away by unstalling the Windows updates.
- NiteOwlBrass Contributor
Gordon Hertzman A recent Office patch has changed the behavior of databases that are not in a 'Trusted Location'. Make the database location a 'Trusted Location' and it should fix this issue.
- Gordon HertzmanCopper ContributorThank NiteOwl I will definitely try this!
- Gordon HertzmanCopper ContributorThank you Karl!
On my own machine I think I was able to solve the problem by uninstalling updates. I believe that is consistent with the fix in your link. I can't believe that Microsoft does not have a fix for this.