We help IT Professionals succeed at work.

Access 2007 Runtime, Mapped Drive, and Trusted Locations

ttist25 asked
Medium Priority
Last Modified: 2013-11-29

I've got a Microsoft Access application that has a frontend/backend setup.  The frontend looks for the backend on the K:\ drive.

I'm installing to a very small site on a Windows XP laptop using the Access 2007 runtime.  I'm mapping a local share to K: and placing the backend in the K: drive then running the frontend (accdr) from the Desktop.  When I start the app I'm presented with an empty Access window and I'm not seeing any of the application's controls.

Similar behavior is exhibited under one of two conditions, either the drive letter is incorrectly mapped, or there is a trust center issue.  I've installed this on Windows 7 PC's with the Access runtime and on Windows XP PC's with the full version of Access without issue, but this is the first Access Runtime/WinXP install I've done.  

I've been looking around and I see reference to a reg edit that allows you to add a trusted location but it doesn't seem to be working for me.

What is the registry modification(s) that I would need to make to allow the frontend to run from the user's desktop and connect to the backend which is a network drive mapped to a local folder share?

Thanks in advance!    
Watch Question

Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
You just need to map the users desktop as a trusted location (although I'm not sure I would want to do that).  I generally put trusted applications in "C:\Users\firstname.lastname\AppData\Local " and have that mapped as a trusted location.

If you have any of the other Office applications on that computer, you can create that trusted location using those applications.
Yes, I agree with fyed to not use the Desktop as Trusted Location.

You can create a Script to change the setting in Registry, see below code:

Dim ChangeReg As Object

Set ChangeReg = CreateObject("WScript.Shell")
ChangeReg.Regwrite "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Access\Security\VBAWarnings", "1", "REG_DWORD"

Open in new window

Hope this helps,
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010


What does that script accomplish?  Does it totally override the VBA security warnings (for all Access applications and only Access application)?
you have to manually or programatically (VBA) create the new Reg keys on each client PC, take a look at


you might need to do VBA warnings & sandbox settings as well
The VBAWarnings is actually for enable Macros to run without warning (enable all macros)

To add a trusted location, you can use some code, found in here:

Check the last Function AddTrustedLocation() by pere_de_chipstick.

More info on registry settings etc. you can find in TechNet:

Hope this helps,


Thanks guys

Explore More ContentExplore courses, solutions, and other research materials related to this topic.