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 ...
If you hold shift when entering the database, then go to Access options and disable Macro security..?
ReplyDelete