I am trying to use group policy to add a subdirectory of the user's home directory as a trusted location for Microsoft Access 2007 (User Configuration/Administrative Templates/Microsoft Office Access 2007/Application Settings/Security/Trust Center/Trusted Locations). However, where I'm having difficulty is that it doesn't seem like the group policy works with a relative path (%userprofile%\My Documents\Subdirectory). Is that true? If so, would a feasible workaround be a loginscript that adds the appropriate registry key?
An alternative would be to use the Auto FE Updater. This utility has an option to set the trusted location of the FE automatically. It will also copy down new Access FEs and associated files when updates are made available on the server, create shortcuts and more.
I would also suggest using a subfolder of the %appdata% aka Application Data folder to store the Access FE and associated files as this is somewhat hidden and thus less likely for the users to muck with the files.
for the logon script way, you should add the path to:
Where X is the location number
for %userprofile%, i didn't try yet