Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Access Security Notice using Runtime 2010

02 Jan 2014   #1

Windows 7 Pro x64
 
 
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)
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\>
I've attempted several different registry combinations within different locations and nothing worked (not even changing the default Trusted Location).
  • 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!

My System SpecsSystem Spec
.

02 Jan 2014   #2

Windows 7 Pro x64
 
 

I just attempted to disable the HyperLinkWarning and the protocols using the registry as well:

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common

Click the registry subkey, point to New on the Edit menu, and then click Key.
Type Security, and then press Enter to name the key.
On the Edit menu, point to New, and then click DWORD Value.
Type DisableHyperlinkWarning, and then press Enter to name the entry.
In the right pane, right-click DisableHyperlinkWarning, and then click Modify.
In the Edit DWORD Value dialog box, click Decimal, and then type 1 or 0 under Value data.
Note A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message.


HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\xx.0\Common\Security\Trusted Protocols\All Applications

Note In this subkey, replace "xx.0" with 12.0 for Outlook 2007 and with 14.0 for Outlook 2010.
Click the All Applications subkey.
On the Edit menu, point to New, and then click Key.
Type the name of the protocol that you want to exclude. For example, to disable the display of a security warning for the "Notes:" protocol, type Notes:.

Note Make sure that you include the colon ( : ) character.

The problem with the last one is that the Office folder does not exist most likely because it is Runtime version.
My System SpecsSystem Spec
02 Jan 2014   #3

Windows 7 Pro x64
 
 

Well my co-worker took a look at it and figured out that it was missing a key one directory back...

"AllowNetworkLocations"=dword:00000001

With that it allows Trusted Locations using network shares or mapped network drives. Which in my case was where the database was located...

For anyone who's reading this and has a similar issue you can try creating the Trusted Location using another computer that has the full version of access, export the keys, modify the user SID, and import to the computer with the runtime version! Just don't forget that AllowNetworkLocations!
My System SpecsSystem Spec
.


Reply

 Access Security Notice using Runtime 2010




Thread Tools



Similar help and support threads for2: Access Security Notice using Runtime 2010
Thread Forum
Microsoft Security Bulletin Advance Notice March 12th 2013 News
Access 2003 Runtime Microsoft Office
Help with mscoreei, security notice General Discussion
Notice: Office Professional Plus 2010 Microsoft Office
PES 2010 C++ runtime problem Gaming

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 01:35 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33