Eliminate the security warning at the startup

Question

While opening any MS Access database, a security warning appears saying that the file can be harmful to the computer. However, is there a way to remove this message. Or should it remain a necessary evil

Solution 1

You can probably sign your program. I don't know for sure. Read this article and see if the same principle applies.

Solution 2

If you lower the security settings in your Access options it will go away I believe. Of course those settings are set where they are for a reason.

Solution 3

Here are some more notes on certification and security.

Certification, including self-certification: http://office.microsoft.com/en-us/access/HP010397921033.aspx

General information on security principals for Office code and macro security: http://office.microsoft.com/en-us/ork2003/CH011480831033.aspx

Trusted location defaults for Office 2003 http://office.microsoft.com/en-us/ork2003/HA011403181033.aspx?pid=CH011480851033

Macro security in Office 2003 http://office.microsoft.com/en-us/ork2003/HA011403071033.aspx?pid=CH011480831033

Solution 4

You can eliminate the security warning at the startup of a ms-access project by putting the access project in a Trusted Location. Or Better yet, make your own Trusted Location.

I recommend creating a folder in the System (C) drive with the name of your project. For example, we could call the folder Database (Path: C:\Database)

Then enter this path as a registry key like this:

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location20] "Path"="C:\Database" "Description"="Access Project location"

Now lets explain a few things about what this key did:

• The number "14.0" is the version of MS Office. You can simply change that to the number that represents the version you are running.
• The "Location20" is a unique name that we assigned. The 20 can be any number that is not already used. Other programs, including default MS Access wizards, already may have used other numbers. Or if you want to make more then one path as a trusted location, then each location must end with a different number.
• The "C:\Database\" actually is the physical path that you want to set to be a Trusted Location. You can put any path that you choose here. I am not sure why it uses double \, but I just copied the example of how the previous keys were set up and this seemed to work best.
• The Description is not needed, but obviously any description can be used.

For more details on how to make Trusted Locations work for your MS Access project, read our detailed explanation here: http://blog.ideaz.net/2013/12/how-to-remove-microsoft-access-security.html

View more solutions