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