Full Version: A Potential Security Concern has been Identified
UtterAccess Discussion Forums > Microsoft® Access > Access Security
FishTracker
Using the deployment wizard from the Access Developer extensions on Access 2007 I put together a package to install an .accdr (.accde) database. I specified Local User when building the package.
When I install the database and runtime to the local c: drive on an XP system it installs and runs fine. But, the client requires this database to be on a shared drive. When I move the db to the S drive and execute it I get the message "A Potential Security Concern has been Identified" message.
I can't get to the Access 2007 Security Center via the runtime system to Trust Center to make the S drive a Trusted Location. Any Suggestions?
HiTechCoach
Try setting the registry keys:


From VBA use something like:
CODE


Dim shl As New WshShell



' AllowNetworkLocations



shl.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\\AllowNetworkLocations", 1, "REG_DWORD"



shl.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\MyAppName\path", "\\server\ShareName\"
FishTracker
Thanks for the lead, Coach. Registry updating is new territory. I'll dig into it.
russb
Hi there
For an excellent utility to download that will write trusted locations go to:

http://www.accessribbon.de/en/?Trust_Cente...usted_Locations

This does all the hard work for you.
Russ

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.