Can 'trusted locations' be set via automation?
Posted on 2011-09-27
We will soon be using the Access2007 runtime to run database applications on Citrix.
Each user will have a front end copy of each database on their 'M:\apps' folder. The Access run time will be installed on the citrix server.
In testing this, I see of no ('easy') way of setting this as a trusted location, short of a registry hack that I have seen in other posts.
Is anyone using automation to set a trusted network location for access databases? If so, how please?
Can it be done with 'group policy' or via a login script? (other ideas I have read, but don't fully understand.)
Lastly: The citrix server is currently running a full version of Office 2000, including Access 2000. It will soon be updated to Microsoft Office 2010 Standard. Until then Access 2000 will be on there, but is it ok to install the Access2007 runtime and have it co-habitate with Access 2000 so I can really test using the run time? Or will that cause conflicts, (having both...) etc...