473,750 Members | 2,270 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Disable Access Security Notice

20 New Member
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 86553
MMcCarthy
14,534 Recognized Expert Moderator MVP
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 Recognized Expert Contributor
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 New Member
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 Recognized Expert Contributor
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 Recognized Expert Contributor
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 New Member
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 Recognized Expert Contributor
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 Recognized Expert Contributor
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 New Member
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

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

Similar topics

2
1356
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
2816
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 past Access (or other) security? It'd be interesting to know. And no, I don't have any prejudices. Yours, Mike MacSween
11
2197
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 not wish to use Access security and what they are more focused on is a solution for when a user performs a critical action the system can verify that it is actually that user, e.g. Checks User Name and Password in a table in place of just selecting...
3
1528
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 database throughout the day. I haven't worked with the Access Security wizard but have this question - will different individuals be able to sign on and off of the database on this PC without logging on to the PC itself? That is to say, will the...
5
2185
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 which I split. So I thought that I'd implement security on it. The security worked great for both groups (i.e. Admins & Users), but after looking at the detail I took it a little further.
0
2095
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 allow it ro run then it will execute, the code execution depends on the permission provided to the assembly. If the code is not trusted wnough to run or it attempts to perform an action which doe not have the required permissions then its execution...
3
3221
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 would hate to disable the security for the whole project (or module) because of a single function. Thank you
1
1916
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 prevented from writing to the Registry or writing a file to the local disk. My question: Is this feature unique to .NET? Or is it just as easy for enterprise network administrators to prevent COM applications from writing to the Registry and doing...
7
2630
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. The users of the database also use other databases therefore I want to secure this database without using the wizard so it does not effect their other databases.
0
9000
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8838
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9577
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9339
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8260
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6081
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4713
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4887
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3322
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.