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:
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!
Bulk.com / Bulk Ltd - First Order Discount Code! Get 35% off of your first order at Bulk, home of award-winning Sports Supplements, high ...
I got this message installing a HP CM1312 on an SBS server, how on earth it is justifiable that an SBS server doesnt meet requirements is be...
Deploying WVD Fails with a conflict error and when clicking for more information it presents a conflict and not much else that is useful by ...