Are you annoyed with the frequent popup of Security Warnings In MS Access? Do you have any idea why this security warning continuously appearing on your MS Access screen? Well if you are looking for the fixes then don’t get worried as this blog will help you out in removing such security warnings.
As this blog specifically targets on providing the 4 different ways to fix off the MS Access security warnings. So just try them and easily get rid of such annoying security warning message.
What Is Access Security Warnings?
One very common grip among MS Access 2007/2010/ 2013/2016 users is the security warning which pop-ups every time when you open a database from any untrusted location. Following here is the screenshot of the error:
The message bar throws security alerts when there is potentially unsafe, active content in the documents you open. Suppose, the document might contain a signed or unsigned macro with an invalid signature. In such cases, the security message appears by default to alert you about the problem.
To fix this issue, many of you use the Access Runtime which makes it even harder to create or add trusted locations. In order to remove off the security alert in Access 2010/2013/2016 you must try out the below mentioned fixes.
What’s The Reasons For Microsoft Access Security Warnings?
MS Access Security Warnings: “A potential security concern has been identified” may occur on your computer screen under these circumstances:
- MS Access runtime file has recently been updated
- May be the program file is not located in a trusted location.
- Someone installed the program but someone else is logged in and trying to use it.
How To Remove MS Access Security Warnings?
1#Removing Security Warning In Full Version Of MS Access
Users of Access full version 2007/ 2010/2013/2016, you need to change the macro security settings to get rid of the Microsoft Access Security notice.
- First of all go to the Microsoft Office Button, and then tap to the Access Options.
2. After then hit the Trust Center link which is present at the bottom of options list.
3. This will open the Trust Center dialog box.
4. Tap to the Macro Settings link and then tap to the right panel for selecting the radio button that says: Enable all macros (not recommended; potentially dangerous code can run)
2#Removing Security Warning When Using Access Runtime
If you have already created an application with MS Access you may want to distribute it with the free MS Access runtime version. so if you are getting Security Warning when using Access Runtime then you can’t remove it with settings. But you can keep the database in some Trusted Location or can use a Registry key to make your folder a trusted location.
Its quiet easy to do this task once you know what key you need to set. Well the registry key is different for each Access version but there is a sample key for MS Access 2010:
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location20] “Path”=”C:\\Database\\”
“Description”=”My Database location”
Explanation about the key:
– The number “14.0” is the version of MS Office. You can change the numbers that represent the version you are executing.
– The “Location20” is a unique name that you assign. 20 can be any number that is not previously used. Other programs include default MS Access wizards, already have used other numbers. But if you want to make more than one path as trusted location, then each location must end up with different number.
– The “C:\\Database\\” is the physical path that you want to set to be as Trusted Location. You can place any path that you choose here.
By copy and pasting the above coding into a text file and save it with a name such as RemoveSecurityWarning.reg, you can then run the file into your PC’s registry just by making double click on the file.
YOU MAY ALSO LIKE:
3#Creating A .Reg File That Will Create A Trusted Location For Any Version Of MS Access:
This step will create a Trusted Location for MS Access 2010 because version 14.0 is the Access 2010 version. But if you are unaware about what version of MS Access your client is using or what if you want this to work for multiple clients using various versions.
Registry doesn’t make any issue, if you create any registry key for version that doesn’t exist. So, you can simple duplicate the key mentioned above for each version that has very less chance to have.
Here is the list of office versions, so now you can easily know about your Access Version.
Access 97 (version 8.0), Access 2000 (version 9.0), Access 2002 (version 10.0), Access 2003 (version 11), Access 2007 (version 12.0), Access 2010 (version 14.0), and Access 2013 (version 15.0).
Version prior to 2007 is not considered above, so we need to include these version numbers 11.0, 12.0, 14.0, 15.0. Here is above registry key copied to include all four of these versions.
[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Trusted Locations\Location20]”Path”=”C:\\Database\\””Description”=”My Database location”
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location20]”Path”=”C:\\Database\\””Description”=”My Database location”
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location20]”Path”=”C:\\Database\\””Description”=”My Database location”
[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Access\Security\Trusted Locations\Location20]”Path”=”C:\\Database\\””Description”=”My Database location”
Save this text in notepad with name like RemoveSecurityWarning.reg and run it by double tapping.
4#Creating a Trusted Location for your Access project using the Package and Distribute feature built into MS Access:
If you are an Access Developer who is annoyed a lot with the security warning then this steps will surely give you the relief. If you are distributing MS Access projects to clients, it’s better to use the handy package solution that allows you to choose the folder your database is installed in and enter some custom registry keys.
Follow these steps:
1) To make a MS Access installer package, tap on the File menu and hit the Save & Publish option. After then on the right pane, hit the Package Solution button.
2) This will open the launch Package Solution Wizard. Choose your destination folder and click the next option.
3) After then you see the Installation Options page is get opened.
– In the File to package field choose your Access file.
– Within the Root install folder field choose System Drive option.
– In the Install sub-folder field assign name to the folder you want your project to get installed into the client’s PC. But make sure the path should be same as you feed later in the registry key. – You can try other options also on this page as per your need and then tap to the Next option.
4) This will open the page with a section called Additional Registry Keys. Here you need to enter the key that will make the folder where your Access projects get installed into a Trusted Location.
– go to the section near the bottom of the page and tap to the Add button.
– In the Root column, choose Current User.
-Within the Key column, enter key such as: Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location20
(Note: here 14.0 is for Access 2010 version. If you are using different version, enter some appropriate version number or you can also add additional keys for each of the version.)
– In the Name column enter the Path
– within the Value column, enter the Path you choosed earlier, like: C:\Database\
– After entering the key, tap to the Next button.
5) Now must have reached to the final page of the Package Solution Wizard. So assign some Product Name for your project and enter whatever information you wish on this page. At last press the OK option.
6) After tapping to the OK option, it will ask you to save the wizard settings. So save it properly so that you can reuse it again for the next time.
Now when you install the access database on your clients PC, they won’t get any irritating Microsoft Access Security Notice each time they run their application.
Users need to be very careful about which locations are added as a trusted location. Instead of setting down the whole documents folder as a trusted location it’s better to have a sub-folder or another dedicated folder, just for trusted access databases.