What Is a Trusted Location in Microsoft Access?

Understanding Trusted Locations

A Trusted Location is a folder or network path that Microsoft Access recognizes as safe. Any database stored in this location bypasses macro security warnings, allowing VBA code, automation scripts, and forms to run without interruption.

Trusted Locations are essential for:

• Multi‑user Access databases
• Front‑end applications in split FE/BE deployments
• Automated processes and scheduled tasks
• Databases containing VBA, macros, API calls, or automation logic

For a deeper overview of multi‑user stability, see our Microsoft Access Multi‑User Best Practices.

For broader Access security strategies, see Microsoft Access Database Security Guidelines.

What Happens Without a Trusted Location?

If a database is opened outside a Trusted Location, Access displays security warnings such as:

• "Security Warning: Macros have been disabled."
• "You are opening a database that contains potentially unsafe content."
• Yellow or red banners prompting users to “Enable Content”

These warnings protect users — but they also disrupt workflow, confuse non‑technical staff, and slow down operations. Trusted Locations eliminate these interruptions for verified safe files.

Security warnings often appear alongside corruption risks. Review Prevent Microsoft Access Database Corruption.

Without a properly configured trusted location in Microsoft Access, users experience constant security prompts that slow workflow and cause confusion.

How to Create a Trusted Location (All Versions)

The steps are nearly identical across Access 2010, 2016, 2019, and Microsoft 365.

1. Open Microsoft Access.
2. Go to File → Options.
3. Select Trust Center.
4. Click Trust Center Settings.
5. Select Trusted Locations.
6. Click Add new location…
7. Browse to the folder you want to trust.
8. Enable Subfolders of this location are also trusted if needed.
9. Click OK.

For a complete Access hardening checklist, see our Microsoft Access Security Hardening Guide.

For deployment environments, see the Microsoft Access Runtime Deployment Guide.

Trusted Locations on Network Drives

By default, Access does not trust network paths. To enable them:

1. Open Trust Center Settings.
2. Select Trusted Locations.
3. Check Allow Trusted Locations on my network.

This is mandatory for multi‑user Access databases stored on a Windows file server. For guidance on proper FE/BE deployment, see Access Front‑End Deployment Best Practices.

For additional multi‑user configuration guidance, see Multi‑User Microsoft Access Database Tips.

Best Practices for Trusted Locations

• Use Trusted Locations only for verified, safe databases.
• Restrict folder permissions to authorized users.
• Use separate folders for different applications.
• Enable subfolders only when necessary.
• Never trust folders synced by OneDrive, Dropbox, or SharePoint.
• Use a Windows file server for multi‑user environments.

For multi‑user reliability, review our Prevent Microsoft Access Database Corruption Guide.

For performance improvements, review the Microsoft Access Database Optimization Guide.

Advanced: Trusted Locations for Front‑End Distribution

In a split database architecture, each user receives a local front‑end copy. To avoid security warnings:

• Create a Trusted Location on each user’s PC (e.g., C:\AccessApps)
• Deploy the front‑end to that folder
• Use an auto‑update script to distribute new versions

For a complete deployment strategy, see our Front‑End Deployment Automation.

If you manage multiple Access files, consider Consolidating Microsoft Access Databases.

Troubleshooting Trusted Location Issues

If warnings persist after adding a Trusted Location, verify the following:

• The database is stored in the exact trusted folder
• The network path matches (UNC vs mapped drive)
• “Allow Trusted Locations on my network” is enabled
• No OneDrive/SharePoint sync conflicts exist
• The file is not blocked by Windows SmartScreen

If issues continue, group policy or IT restrictions may be overriding local settings.

When Trusted Locations Are Not Enough

Trusted Locations remove warnings — but they do not address deeper architectural issues such as:

• Database corruption
• Slow performance
• Record locking conflicts
• Large file sizes
• Security limitations

For growing databases or multi‑user environments, upgrading to SQL Server is the long‑term solution. See our Access → SQL Server Migration Guide.

For hybrid architecture guidance, see SQL Server Integration for Microsoft Access.

Configuring a trusted location in Microsoft Access ensures smooth operation, eliminates warnings, and supports stable multi-user performance.