?
Solved

Access Runtime 2010 Trusted Network Locations

Posted on 2010-08-17
7
Medium Priority
?
5,589 Views
Last Modified: 2012-05-10
Hello,

We are upgrading to an Office 2010 Standard environment from Office 2000. We plan on running Access Runtime 2010 on our clients but have run into some trouble with trusted locations and/or documents on the client machines.

I've followed everything in the ticket listed below but still no luck:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26342108.html?sfQueryTermInfo=1+10+2010+30+access+runtim+secur+warn


The trusted locations work if the databases are run from the local client machine but not from a network location. I've manually created registry entries and also used the tool listed at the following link:
http://www.accessribbon.de/en/index.php?Trust_Center:Trusted_Locations


When manually creating or modifying the registry entries I've tried including the full network location (\\servername\directory\) and also tried with the network share location (X:\directory\) for the Path entry but nothing appears to work.

Has anyone run into a problem similar to this?
0
Comment
Question by:jkassil
7 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33459534
Have you enabled Network Locations in the Trust Center?
(In Access 2007 it is located here, I am sure it will be something similar in Access 2010)

Office Button-->Access Options-->Trust Center-->Trust Center Settings-->Trusted Locations
Then Check ON the box for:  Allow Trusted Locations on my Network
(But note the warning about this not being recommended...)

If this does not solve the issue then you should turn off this option, to be on the safe side


JeffCoachman
0
 

Author Comment

by:jkassil
ID: 33465944
Hi Jeff,

Thanks for your response. After a closer look, Trust Center settings are not available in the Runtime version of Access. I can set the setting you mentioned above in a different Office Application, but it looks like the entry is only reflected for that specific application (i.e. changing the setting in Word does not also change it for Excel, PowerPoint or Access).
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33467497
Makes sense as the runtime is akin to a "Stand alone" application...

But leave this Q open for a few more days to see if another Expert has any more input...

;-)

Jeff
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Accepted Solution

by:
jkassil earned 0 total points
ID: 33468008
Answer Found.

Registry Keys should be as follows for Access runtime to allow network location databases to be run:

=======================================================================
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security]
"VBAWarnings"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations]
"AllowNetworkLocations"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location#]
"AllowSubFolders"=dword:00000001
"Path"="\\server\location\"
=======================================================================

Seeing that these are an HKCU, they can be added via the OCT after application install has been carried out.
0
 
LVL 75
ID: 33468098
Good Info !!

mx
0
 

Expert Comment

by:Andreas200
ID: 34161962
I have a Windows 7 PC in a workgroup with Access 2010.
I opened on this PC a VPN to a remote Windows XP PC in a domain and  tried to to access a remote mdb (Access 2010) using a mapped drive.

I could not get it working without security pop-up until I added "VBAWarnings"=dword:00000001
Thanks for the Tip!
Andreas
0
 

Author Comment

by:jkassil
ID: 34163972
Thanks.
Just an update about the OCT; that never did work. We ended up making a .reg with the registry entries in it and ran it on everyone's PC. Not elegant, but it worked.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question