Office Settings & Configuration

Deploy Microsoft Access Trusted Locations for Multiple Users

Maira MehtabMaira Mehtab Oct 19, 2026 871 views

Question details

The user needs a method to configure a trusted location across 25 to 30 computers without manually updating each machine.

Deploy Microsoft Access Trusted Locations for Multiple Users
Product
Microsoft Access
Device & OS
not provided
Scenario
Distributing an Access front end connected to a SQL Server to multiple user desktops across a domain network.
Observed behavior
Users receive security warnings when opening the distributed database because the target folder is not recognized as a trusted location by default.
Before you start

Ensure you have domain administrative privileges to edit Group Policy Objects (GPOs) and verify the exact folder path where the Access front end is distributed on the user machines.

Solution 1Recommended

Deploy Trusted Locations Registry Settings via Group Policy

Use domain Group Policy Preferences to automatically push the required Microsoft Access Trusted Location registry settings to all user machines.

Group Policy is the most efficient and scalable method for configuring trusted locations across a domain. By creating a Group Policy Object (GPO) that updates the Windows Registry, the specified folder will automatically be trusted for all users.

1
Open Group Policy Management

On your domain controller, press Win + R, type 'gpmc.msc', and press Enter to open the Group Policy Management Console.

2
Create or Edit a GPO

Create a new Group Policy Object linked to the Organizational Unit (OU) containing your users, or right-click an existing GPO and select 'Edit'.

3
Navigate to Registry Preferences

In the Group Policy Management Editor, go to User Configuration > Preferences > Windows Settings > Registry.

4
Add Trusted Location Keys

Right-click and select New > Registry Item. Set the Action to 'Update' and configure the Key Path to 'Software\Microsoft\Office\[YourVersion]\Access\Security\Trusted Locations\Location1' (replace [YourVersion] with your Office version, e.g., 16.0).

5
Configure the Path Value

Add a String Value named 'Path' and set its Value data to the exact directory path where the Access front end is stored. Apply the policy to deploy the settings.

Deploy Trusted Locations Registry Settings via Group Policy
Network Paths: If you are trusting a network share instead of a local desktop folder, you must also create a registry key for 'AllowNetworkLocations' and set its DWORD value to 1.
Free Microsoft Office alternative

Looking for a Lightweight Office Suite? Try WPS Office

While Microsoft Access is a specialized database tool, WPS Office provides a lightweight, highly compatible, and free alternative for all your core document, spreadsheet, and presentation needs.

  1. 1. Download WPS Office: Visit the official WPS website to download the free installation package for your operating system.
  2. 2. Install the Software: Run the setup file and follow the on-screen instructions to complete the fast, lightweight installation.
  3. 3. Open Your Office Files: Instantly open and edit your existing .docx, .xlsx, and .pptx files with perfect formatting compatibility.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formatsLightweight installation with faster launch speeds and lower memory usageFamiliar tabbed user interface requiring zero learning curveBuilt-in PDF editing, conversion, and annotation tools
microsoft office alternative - wps office

Frequently Asked Questions

What is a Trusted Location in Microsoft Office?

A Trusted Location is a specific directory designated as safe by the user or administrator. Files opened from these folders bypass the standard Trust Center security checks, suppressing macro and active content warnings.

Can I configure Trusted Locations for network drives?

Yes, but by default, Microsoft Office disables trusting network locations for security reasons. You must explicitly enable the 'Allow Trusted Locations on my network' setting in the Trust Center or via registry before network paths will be recognized.

Where are Microsoft Access Trusted Locations stored in the Registry?

They are stored in the Current User hive under HKEY_CURRENT_USER\Software\Microsoft\Office\[Version]\Access\Security\Trusted Locations. Each trusted folder has its own subkey containing 'Path', 'Date', and 'AllowSubfolders' values.