Microsoft 365 Error Codes

How to Fix Access Runtime Error 3014 After Microsoft 365 Release 2201

Anum MushtaqAnum Mushtaq Nov 3, 2026 869 views

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.

How to Fix Access Runtime Error 3014 After 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.
Before you start

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.

Solution 1Recommended

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.

1
Open Trust Center Settings

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.

2
Navigate to Trusted Locations

In the Trust Center window, select 'Trusted Locations' from the left-hand menu.

3
Add a New Location

Click the 'Add new location' button near the bottom. Browse to the specific folder where your Access database is stored.

4
Apply and Confirm

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.

Add Your Database Folder to Trusted Locations
Workaround Verified: Many users have confirmed this method successfully restores normal VBA generation and database functions without downgrading their Office version.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and click the free download button to get the installation package.
  2. 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
  3. 3. Open Your Documents: Launch WPS Office and open your existing Office files directly to continue working without compatibility issues.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight installation that avoids the heavy system resource usage of standard office suitesFree to use with an intuitive, familiar user interface for seamless migrationStable environment without unexpected macro-breaking forced updates
microsoft office alternative - wps office

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