How to Fix Access Runtime Error 3014 After Microsoft 365 Release 2201
Question details
Users need to resolve Runtime Error 3014 in Microsoft Access, which prevents opening more tables or running previously working VBA code after updating to Microsoft 365 release 2201.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Running VBA code or generating files in a Microsoft Access database.
- Observed behavior
- Microsoft Access throws Runtime Error 3014 stating it 'cannot open any more tables' when running VBA code that functioned perfectly on previous Microsoft 365 builds.
Ensure you have administrative privileges on your computer, as reverting to an earlier version of Microsoft 365 or modifying Trust Center settings will require administrator access.
Add Your Database Folder to Trusted Locations
Adding the directory where your database resides to Access's Trusted Locations bypasses security restrictions introduced in recent updates that trigger the 3014 error.
This workaround is often the fastest way to resolve the VBA code execution issue without having to uninstall or roll back your entire Microsoft 365 suite. It tells Microsoft Access that the files in this specific folder are safe to execute.
Launch Microsoft Access, click on 'File' in the top-left corner, select 'Options', and then navigate to the 'Trust Center' tab. Click the 'Trust Center Settings' button.
In the Trust Center window, select 'Trusted Locations' from the left-hand menu.
Click the 'Add new location' button near the bottom. Browse to the specific folder where your Access database is stored.
Check the box that says 'Subfolders of this location are also trusted' if your database relies on subdirectories, then click 'OK' to save your changes and restart Access.

Roll Back Microsoft 365 to a Previous Version
If adding a trusted location is not feasible for your environment, you can revert Microsoft 365 to a stable build (such as version 16.14729.20260) prior to release 2201.
Experience Stable Document Management with WPS Office
If unexpected update errors in Microsoft 365 are interrupting your workflow, consider using WPS Office. It provides a highly compatible, free, and lightweight alternative for your daily document, spreadsheet, and presentation tasks, allowing you to maintain productivity without forced update disruptions.
- 1. Download WPS Office: Visit the official WPS website and click the free download button to get the installation package.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Documents: Launch WPS Office and open your existing Office files directly to continue working without compatibility issues.

Frequently Asked Questions
What causes Runtime Error 3014 in Microsoft Access?
Error 3014 typically indicates that the database engine has reached the maximum number of tables it can open simultaneously. In this specific scenario, however, it is caused by a known bug introduced in Microsoft 365 release 2201 that incorrectly handles VBA table operations.
Is it safe to add folders to Trusted Locations in Access?
Yes, as long as you add a folder that you have created and fully control. Adding a folder to Trusted Locations tells Office to bypass security checks for macros and VBA code running from that specific directory, which safely bypasses the bug causing the error.
How do I know when it is safe to re-enable Microsoft 365 updates?
You should monitor the Microsoft 365 Apps release notes or Microsoft Community forums. Once a subsequent build explicitly lists a fix for the Access Runtime Error 3014, you can safely go back to File > Account > Update Options and select 'Enable Updates'.




