Access 2007 Runtime, Mapped Drive, and Trusted Locations
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!
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!
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.lastna
If you have any of the other Office applications on that computer, you can create that trusted location using those applications.
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:
Hope this helps,
Daniel
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"
Hope this helps,
Daniel
Daniel,
What does that script accomplish? Does it totally override the VBA security warnings (for all Access applications and only Access application)?
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
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
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
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