Problem: We have application created in MS Acces 2003(vba) , Now We want to make it available in MS Access 2007/2010. This application is opening in MS Access 2007/2010 but it displays some security warning ." Enable Content" , Now after adding file to trusted location it opens with out any warning.
We want to automate this process means we donot want to add this folder in trusted location manually.
We want some code in VBA OR in C#.
Early response will be appreciated.
Suggest for you to search the internet for "VBA code signing certificate". Cryptographically signing your code might help, especially if you have corporate administrative control over the security settings within Access... But if you have this kind of administrative control, perhaps there is some way to centrally configure the Access Trusted Location settings (the solution you are asking for)... I don't know how to do this.
Matthew Slyman M.A. (Camb.)
It's simply a registry entry (see, for example, http://www.accessjunkie.com/Pages/faq_33.aspx), so I'm pretty sure it can be set through GPOs. Unfortunately, I'm not an expert on GPOs.
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele (no e-mails, please!)
Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)
+1 to Douglas.
It's registry keys under HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations, you may add the trusted location manually and export corresponding registry entry as a reg file.
If you're in domain environment, you can specify domain computers execute script when logon. Open Local Group Policy Editor of domain controller, it's in Computer Configuration -> Administrative Templates -> System -> Logon. Run these programs at user logon.
Forrest Guo | MSDN Community Support | Feedback to manager