Page 1 of 1

Microsoft Access Trusted Folder

Posted: Sat, 17. Jun 2017 14:50
by mho
When linking the HELGA tables from a Helgadat.mdb in a different folder than C:\HELGA or even a different computer in a network, you may get a warning message for each table.
To avoid this hassle, you need to declare the folder or path as "trusted".
If you have a full version of Access, simply go to Options and enter the required information.
Trusted1.png
Trusted2.png
Trusted3.png
If you have the free Runtime version of Access, you can only configure the Trusted Folder via the Registry.
Create a new Text file and put the following lines. Save it, and change the extension to .REG (make sure you display the actual extensions in the Explorer!). Double click on it to enter the information into the registry.
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations]
"AllowNetworkLocations"=dword:00000001
"AllLocationsDisabled"=dword:00000000

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\location_HELGA]
"Path"="E:\\Helga"
"AllowSubfolders"=dword:00000001
"Description"="HELGA database on E drive"

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\location_HELGA_net]
"Path"="\\\\SERVER\\Helga"
"AllowSubfolders"=dword:00000001
"Description"="HELGA database on network path"
  • You only have to configure the variation you need (local and/or network drive).
  • The Office version to set depends on your Runtime version:

    14.0 = Access 2010
    15.0 = Access 2013
    16.0 = Access 2016

Re: Microsoft Access Trusted Folder

Posted: Sat, 23. Nov 2019 12:00
by mho
See also here