473,320 Members | 2,117 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Disable Access Security Notice

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?
Jan 29 '08 #1
17 86438
MMcCarthy
14,534 Expert Mod 8TB
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.
Feb 5 '08 #2
mshmyob
904 Expert 512MB
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?
Feb 5 '08 #3
JKoyis
20
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.
Feb 7 '08 #4
mshmyob
904 Expert 512MB
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.
Feb 7 '08 #5
mshmyob
904 Expert 512MB
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.
Feb 7 '08 #6
JKoyis
20
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.
Feb 8 '08 #7
mshmyob
904 Expert 512MB
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.
Feb 8 '08 #8
mshmyob
904 Expert 512MB
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.
Feb 9 '08 #9
JKoyis
20
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
Feb 12 '08 #10
mshmyob
904 Expert 512MB
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.



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
Feb 12 '08 #11
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
Feb 21 '08 #12
mshmyob
904 Expert 512MB
You're welcome..........

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
Feb 21 '08 #13
JKoyis
20
Works for me too, thanks!
Mar 13 '08 #14
I have win XP SP3. i created the registry file with the 3 lines of code and then double-clicked the file. I received a message saying that the registry was successfully updated. and now my applications running on Access 2007 runtime no longer display the Security Notice dialog box. Thanks for all your help!
Oct 11 '10 #15
mshmyob
904 Expert 512MB
You are welcome. It is always nice to see that older posts are still helpful to users.

cheers,
Oct 11 '10 #16
Thanks mshmyob. I have just signed on to say that. New security key method works for Office 10 Access (Office\12.0 in registry) also. Unfortunately, the user still has three clicks to wade through in IE as my html help files are so dangerous.

Cheers
Nov 1 '11 #17
mshmyob
904 Expert 512MB
LOL - glad it worked for you. Got to watch out for those nasty help files.

cheers,
Nov 3 '11 #18

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Pola | last post by:
Please Help I am using VC++.NET In my appl I have to disable access to some disks in the network How I can do it thank you Pol
32
by: Mike MacSween | last post by:
Further to 'Security - more complex than I thought' Has anybody ever seen any studies? Or anecdotal evidence? Done any studies themselves? Done any lab testing - you know - 10 users asked to get...
11
by: Will | last post by:
I am looking at using a table with user names, passwords and user rights, which I would administer. I have read a lot about the shortfalls of this and the lack of security but the customer does...
3
by: mar10 | last post by:
I'm working on a database for a local business that requires different security for different individuals. There is one PC at the front desk and several individuals will be working with the...
5
by: Greg Strong | last post by:
Hello All, What are the best ways to implement security for Access databases (i.e. ..MDB files)? I ask the question from a general perspective. Why? Well I had written a prototype database...
0
by: Namratha Shah \(Nasha\) | last post by:
Hey Guys, Today we are going to look at Code Access Security. Code access security is a feature of .NET that manages code depending on its trust level. If the CLS trusts the code enough to...
3
by: John | last post by:
Hi, I know, this question was posted a year ago (link below). I wonder whether Microsoft changed it's mind and fixed check_stack pragma to disable buffer security for a single function. I...
1
by: Jeremy S. | last post by:
..NET's code Access Security enables administrators to restrict the types of things that a .NET application can do on a local computer. For example, a ..NET Windows Forms application can be...
7
by: thebarefootnation | last post by:
Hi, I have created an access db that I would like to secure. The database will exist on a shared drive and be used at a number of different locations hence the reason to secure the database. ...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.