SOLVED

Error: Cannot open any more databases

%3CLINGO-SUB%20id%3D%22lingo-sub-3108751%22%20slang%3D%22en-US%22%3EError%3A%20Cannot%20open%20any%20more%20databases%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3108751%22%20slang%3D%22en-US%22%3E%3CP%3EGetting%20this%20error%20all%20of%20a%20sudden%20on%20FOUR%20different%20MS%20Access%20databases%20on%20four%20different%20computers.%26nbsp%3B%20On%20one%20computer%20I%20uninstalled%20Windows%20updates%20and%20did%20an%20Office%20repair.%26nbsp%3B%20Is%20there%20any%20information%20about%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20safely%20say%20that%20it%20is%20not%20related%20to%20file%20locking%20or%20open%20and%20closing%20recordsets.%26nbsp%3B%20No%20changes%20were%20made%20to%20the%20system%20that%20I%20got%20the%20error%20to%20go%20away%20by%20unstalling%20the%20Windows%20updates.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3108751%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3110235%22%20slang%3D%22en-US%22%3ERe%3A%20Error%3A%20Cannot%20open%20any%20more%20databases%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3110235%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Faccess%2Faccess-doesn-t-close-properly-a-remaining-background-process-can%2Fm-p%2F3103807%22%20target%3D%22_blank%22%3ESee%20my%20reply%20in%20a%20similar%20forum%20post%20here%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%222%22%3E%3CFONT%20face%3D%22Verdana%22%3E%3CFONT%20face%3D%22Verdana%22%20size%3D%222%22%3EServus%3CBR%20%2F%3EKarl%3CBR%20%2F%3E************%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FwpPYu6G_xcY%2520%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAccess%20News%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.donkarl.com%2Fdevcon%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAccess%20DevCon%3C%2FA%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3110291%22%20slang%3D%22en-US%22%3ERe%3A%20Error%3A%20Cannot%20open%20any%20more%20databases%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3110291%22%20slang%3D%22en-US%22%3EThank%20you%20Karl!%3CBR%20%2F%3E%3CBR%20%2F%3EOn%20my%20own%20machine%20I%20think%20I%20was%20able%20to%20solve%20the%20problem%20by%20uninstalling%20updates.%20I%20believe%20that%20is%20consistent%20with%20the%20fix%20in%20your%20link.%20I%20can't%20believe%20that%20Microsoft%20does%20not%20have%20a%20fix%20for%20this.%3C%2FLINGO-BODY%3E
New Contributor

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.

5 Replies
best response confirmed by Gordon Hertzman (New Contributor)
Solution
Thank 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.

@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.

Thank NiteOwl I will definitely try this!
it worked for me. Thank you very much @NiteOwl