We help IT Professionals succeed at work.

Access 2007 Runtime, Mapped Drive, and Trusted Locations

ttist25
ttist25 asked
on
Medium Priority
722 Views
Last Modified: 2013-11-29
Hello,

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!    
Comment
Watch Question

Owner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010
Commented:
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,
Daniel
Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010

Commented:
Daniel,

What does that script accomplish?  Does it totally override the VBA security warnings (for all Access applications and only Access application)?
vguzmanPresident
Commented:
you have to manually or programatically (VBA) create the new Reg keys on each client PC, take a look at
http://themausman.blogspot.com/2010/04/access-runtime-version-and-trusted.html

http://www.accessmonster.com/Uwe/Forum.aspx/access-security/11016/Access-2007-Runtime-Security-Trusted-Locations

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:
http://www.utteraccess.com/forum/lofiversion/index.php/t1952992.html

Check the last Function AddTrustedLocation() by pere_de_chipstick.

More info on registry settings etc. you can find in TechNet:
http://technet.microsoft.com/en-us/library/cc178946%28office.12%29.aspx

Hope this helps,
Daniel
 

Author

Commented:
Thanks guys

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