New
#1
Access Security Notice using Runtime 2010
I've created a batch file to run a macro within an Access Database I created. I'd like to have this batch file run automatically without user interaction but the problem is that I'm getting this Microsoft Access Security Notice warning everytime I open the database.
Installed Access Runtime 2010 on my Windows Server 2008 R2.
I spent a few days researching this and attempting several possible solutions with nothing working. Some things I've tried are as follows:
- Adding the database location to the Trusted Location (using Registry)
I've attempted several different registry combinations within different locations and nothing worked (not even changing the default Trusted Location).Code:\HKEY_CURRENT_USER\Software\Microsoft\Office\<version>\Access\Security\Trusted Locations\<location> Path REG_SZ <drive/path to location; Example C:\My Trusted Stuff\>
- Creating a Digital Signature Certificate, but cannot add because runtime doesn't have the ability to do so
The only thing that has worked is placing the database within the default Trusted Location located at C:\Program Files (x86)\Microsoft Office\Office14\ACCWIZ, although this database is being used by many other sources and I cannot simply just move it.
Please I really need some help!