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...
I have to admit, out of all server installs I have ever done, I have probably had one of the worst experiences ever recently with 2008 SBS. ...