Solved

Access Runtime 2010 Trusted Network Locations

Posted on 2010-08-17
7
5,107 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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Correct ordering 16 48
ms/access subform update with refresh/requery 8 24
Max per month 3 15
Help with SQl and UNION 3 16
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now