Solved

Access Runtime 2010 Trusted Network Locations

Posted on 2010-08-17
7
5,341 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
[X]
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
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

724 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