Disable Access Security Notice

[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?

[MMcCarthy]

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.

[mshmyob]

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).

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?

[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.

[mshmyob]

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

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.

[mshmyob]

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

REGEDIT4
 
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"VBAWarnings"=dword:00000001
 

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.

[JKoyis]

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

REGEDIT4
 
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"VBAWarnings"=dword:00000001
 

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.

[mshmyob]

Are you running XP or Vista?

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

I added the code to the registry, but it still gives the warning message, even after restarting Windows.

[mshmyob]

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.

I added the code to the registry, but it still gives the warning message, even after restarting Windows.

[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