Tuesday, 5 July 2011

A Potential Security Concern Has Been Identified : Access Runtime 2007

We found that in Access 2007 to use a database without the trusted location error bugging the user everytime they open it wasn't quite as simple as you might initially suspect using Access 2007 Pro.

To trust a location you have to specify the path in the registry as Trusted Sources / Access Options isn't to be found in the runtime version of Access.

Navigate to the following Key:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations


Create a string for:
'Path': Specify the full path to the database (excluding *.mdb)
'Description' : The description isnt relevant but from testing it appears it is required as an entry.

Additionally create a DWORD value for
'AllowSubfolders' : 1 to trust any subfolders of Path (Not a requirement)

This should eradicate the error from presenting itself, thereby trusting the database.

Did I solve your problem? Buy me a virtual beer by clicking on a Google ad :). Thanks!

2 comments:

  1. Chris
    Thanks for the info above, i am just over the hill in Buxton!
    Came across this problem when trying to deploy a VB.net app that automates Access using 2007 runtime components only, all works ok except the nagging screen, tried the reg mods and various suggested permutations but nothing seems to have any affect? even tried the 2010 runtime components and adding the database as a trusted file but nothing seems to have any affect, am logged on as admin, any suggestions?
    Thanks
    Simon
    ps location i am trying to trust is a network location!

    ReplyDelete
  2. If you hold shift when entering the database, then go to Access options and disable Macro security..?

    ReplyDelete