Microsoft Access Trusted Folder

Questions & Answers, Tips & Tricks, Users help Users
Post Reply
User avatar
mho
100+
100+
Posts: 486
Joined: Sun, 28. Aug 2005 14:52
Contact:

Microsoft Access Trusted Folder

Post 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
User avatar
mho
100+
100+
Posts: 486
Joined: Sun, 28. Aug 2005 14:52
Contact:

Re: Microsoft Access Trusted Folder

Post by mho »

See also here
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest