Microsoft Access cannot open any more databases

Microsoft Access cannot open any more databases

How to fix this error

In the past 2 weeks (as of 07/02/2022) an error message has started plaguing some Microsoft Access databases.

Specifically, databases set up with a front-end and back-end where the data tables are housed in a separate database to the front-end forms and logic.

The error “Cannot open any more databases” will randomly appear and eventually you will be locked out of the database altogether without being able to access anything without bypassing the start-up routines.

The cause of this is still under investigation but the good news is that there appears to be a fix which can help.

Below is a step-by-step guide to fixing this issue:

1.  Close out of the database completely

2.  Open Task Manager by right clicking the Task Bar at the bottom of the screen and selecting Task Manager from the menu that appears.

3.  Scroll down the section entitled Background processes and look for any Microsoft Access processes that are still running. Right click and select End task on all of them:

4.  Click on your database shortcut, hold the Shift key and open your database by pressing the Enter key

5.  Select File -> Options (at the bottom) and the Access Options window will open:

6.  Select Trust Center from the bottom of this screen then click the Trust Center Settings… button on the right which will open the Trust Center screen

7.  Select Trusted Locations near the top of this screen

8.  On the right you will now see a list headed “Path, Description and Date Modified” containing User Locations and Policy Locations in bold text

9.  Click the Add New Location button at the bottom of this screen
Note: If the MS Access database front-end file is in a network location you will need to check the box entitled “Allow Trusted Locations on my network (not recommended)”. If the front-end is on your local machine and the back-end is in a network location you should be able to leave this unchecked

10.  Using the Browse button browse to the location containing your MS Access database front-end file, check the box labelled “Subfolders of this location are also trusted” and click OK.

 

11.  Click OK at the bottom of the Trust Center screen

12.  Click OK at the bottom of the Access Options screen

13.  Close MS Access

Try to open your MS Access database in your usual way and see if the problem has been resolved

Note:  If this does not work then add the location to the back-end database to the Trusted Locations list in the same manner as above.

We hope this guide proves helpful as the message displayed doesn’t really give any clues as the the actul resolution of the issue. If you are still experiancing issues please dont’ hesitate to contact us by completing the form below:

Contact Us