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!
Subscribe to:
Post Comments (Atom)
Bulk discount code 2022 - 35% Off First Order Discount Code at bulk.com
Bulk.com / Bulk Ltd - First Order Discount Code! Get 35% off of your first order at Bulk, home of award-winning Sports Supplements, high ...
Chris
ReplyDeleteThanks 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!
If you hold shift when entering the database, then go to Access options and disable Macro security..?
ReplyDelete