Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Access Runtime 2010 Trusted Network Locations

Posted on 2010-08-17
7
5,240 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
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…
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.
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 …

839 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