Connecting Tech Pros Worldwide Help | Site Map

Disable Access Security Notice

  #1  
Old January 29th, 2008, 08:53 AM
Newbie
 
Join Date: Mar 2007
Posts: 20
I'm trying to put a link on a database form, but access keeps throwing a warning message when I click it:

"A potential security concern has been identified,

this location may be unsafe."

The help mentions unchecking an option in the trust center, but the option isn't listed for me. The link points at a directory in a subfolder of the database's folder, which is listed as a trusted site along with its subdirectories.

Any suggestions?
  #2  
Old February 5th, 2008, 12:33 AM
msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,790
Provided Answers: 2

re: Disable Access Security Notice


What version of Access are you using?

One thing you might try is going to Tools - Macro - Security and make sure the option is set to medium.
  #3  
Old February 5th, 2008, 12:49 AM
mshmyob's Avatar
Expert
 
Join Date: Jan 2008
Location: witness protection
Posts: 610
Provided Answers: 2

re: Disable Access Security Notice


2 ways of doing it. If you are using Access 2007 :

Click on the BIG office button in the top left
Select Access Options
Select Trust Center
Select Trust Center Settings
Select Trusted Locations and add your new trusted location.

This works if you never change the directory where the fiels are located. But if you are using it on a network and people can install anywhere or if you use the RUNTIME you need to change the registery setting.

If you want the registery setting change let me know. The registry setting will turn off this message forever no matter what. It is what I use when I distribute an app to end users with the runtime module.

Just a note that if you distribute with the runtime and you use linked files and people can install wherever they want you will need to implement a feature to allow relinking of the data file(s).

Quote:
Originally Posted by JKoyis
I'm trying to put a link on a database form, but access keeps throwing a warning message when I click it:

"A potential security concern has been identified,

this location may be unsafe."

The help mentions unchecking an option in the trust center, but the option isn't listed for me. The link points at a directory in a subfolder of the database's folder, which is listed as a trusted site along with its subdirectories.

Any suggestions?
  #4  
Old February 7th, 2008, 01:44 AM
Newbie
 
Join Date: Mar 2007
Posts: 20

re: Disable Access Security Notice


Thanks for the replies, I'm using Access 2007.

I've got the database root folder listed as a trusted location, with the subdirectories option ticked, but I'm still getting the warning.

I might have to try the registry method, but ideally I want the database to be portable and installable anywhere.

I'm worried that users will see the message and not want to access the help pages.
  #5  
Old February 7th, 2008, 02:37 AM
mshmyob's Avatar
Expert
 
Join Date: Jan 2008
Location: witness protection
Posts: 610
Provided Answers: 2

re: Disable Access Security Notice


If you use the runtime it will always give you that message no matter what unless you modify the registry.

Quote:
Originally Posted by JKoyis
Thanks for the replies, I'm using Access 2007.

I've got the database root folder listed as a trusted location, with the subdirectories option ticked, but I'm still getting the warning.

I might have to try the registry method, but ideally I want the database to be portable and installable anywhere.

I'm worried that users will see the message and not want to access the help pages.
  #6  
Old February 7th, 2008, 02:22 PM
mshmyob's Avatar
Expert
 
Join Date: Jan 2008
Location: witness protection
Posts: 610
Provided Answers: 2

re: Disable Access Security Notice


Here is how you disbale it using the registry for Access 2007

Expand|Select|Wrap|Line Numbers
  1. REGEDIT4
  2.  
  3. [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
  4. "VBAWarnings"=dword:00000001
  5.  
Just create a text file put these 3 lines in and save it as anything you want but have an extension of .REG.

Then just double clik on it and it will modify the registry to get rid of that annoying message.
  #7  
Old February 8th, 2008, 01:20 AM
Newbie
 
Join Date: Mar 2007
Posts: 20

re: Disable Access Security Notice


Quote:
Originally Posted by mshmyob
Here is how you disbale it using the registry for Access 2007

Expand|Select|Wrap|Line Numbers
  1. REGEDIT4
  2.  
  3. [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
  4. "VBAWarnings"=dword:00000001
  5.  
Just create a text file put these 3 lines in and save it as anything you want but have an extension of .REG.

Then just double clik on it and it will modify the registry to get rid of that annoying message.
I added the code to the registry, but it still gives the warning message, even after restarting Windows.
  #8  
Old February 8th, 2008, 02:45 AM
mshmyob's Avatar
Expert
 
Join Date: Jan 2008
Location: witness protection
Posts: 610
Provided Answers: 2

re: Disable Access Security Notice


Are you running XP or Vista?

Check your registry manually and see if the change took effect.

Quote:
Originally Posted by JKoyis
I added the code to the registry, but it still gives the warning message, even after restarting Windows.
  #9  
Old February 9th, 2008, 12:33 AM
mshmyob's Avatar
Expert
 
Join Date: Jan 2008
Location: witness protection
Posts: 610
Provided Answers: 2

re: Disable Access Security Notice


I just noticed that the code has some spaces in the word Access. This appeared when I added it to theScripts

Make sure Access is one word with no spaces.

Quote:
Originally Posted by JKoyis
I added the code to the registry, but it still gives the warning message, even after restarting Windows.
  #10  
Old February 12th, 2008, 01:34 AM
Newbie
 
Join Date: Mar 2007
Posts: 20

re: Disable Access Security Notice


I'm running XP, and the code is in there with no spaces.

I have Access installed separately (no other office apps), if that makes a difference.

Here's a screenshot from regedit:

http://www.oyis.org/screenshotRegedit.png
  #11  
Old February 12th, 2008, 04:05 PM
mshmyob's Avatar
Expert
 
Join Date: Jan 2008
Location: witness protection
Posts: 610
Provided Answers: 2

re: Disable Access Security Notice


Try this:

In Registry Editor, locate the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon


1. Click the registry subkey, point to New on the Edit menu, and then click Key.
2. Type Security, and then press ENTER to name the key.
3. On the Edit menu, point to New, and then click DWORD Value.
4. Type DisableHyperlinkWarning, and then press ENTER to name the entry.
5. In the right pane, right-click DisableHyperlinkWarning, and then click Modify.
6. In the Edit DWORD Value dialog box, click Decimal, and then type 1 under Value data.

Note A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message.
7. Click OK.
8. Exit Registry Editor.



Quote:
Originally Posted by JKoyis
I'm running XP, and the code is in there with no spaces.

I have Access installed separately (no other office apps), if that makes a difference.

Here's a screenshot from regedit:

http://www.oyis.org/screenshotRegedit.png
  #12  
Old February 21st, 2008, 11:48 AM
attagata's Avatar
Newbie
 
Join Date: Feb 2008
Location: Nagoya JP - Im Brazilian
Posts: 1

re: Disable Access Security Notice


Thanks MSHMYOB, It works for me.

OS. Windows XP (Portuguese/Japanese)
ACCESS RUNTIME 2007


Adding in windows registry:
Code: ( text )
REGEDIT4

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security]
"VBAWarnings"=dword:00000001

Thanks a lot.
Anderson
  #13  
Old February 21st, 2008, 11:54 AM
mshmyob's Avatar
Expert
 
Join Date: Jan 2008
Location: witness protection
Posts: 610
Provided Answers: 2

re: Disable Access Security Notice


You're welcome..........

Quote:
Originally Posted by attagata
Thanks MSHMYOB, It works for me.

OS. Windows XP (Portuguese/Japanese)
ACCESS RUNTIME 2007


Adding in windows registry:
Code: ( text )
REGEDIT4

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security]
"VBAWarnings"=dword:00000001

Thanks a lot.
Anderson
  #14  
Old March 13th, 2008, 01:38 AM
Newbie
 
Join Date: Mar 2007
Posts: 20

re: Disable Access Security Notice


Works for me too, thanks!
Reply


Similar Threads
Thread Thread Starter Forum Replies Last Post
disable/enable the shift key Pietro answers 3 July 26th, 2007 08:56 PM
Create digitally signed MDE files in Access 2007 Chris answers 4 May 17th, 2007 06:25 AM
Custom Context Sensitive Menus within MS Access Keith Hutchison answers 2 February 21st, 2007 03:05 AM
Access XP / MySQL / MyODBC: Access' caching system? onnodb@gmail.com answers 6 August 8th, 2006 08:45 PM