[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Access Runtime 2010 Trusted Network Locations

Posted on 2010-08-17
7
Medium Priority
?
5,491 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

656 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