remove the "Unknown Publisher" security warning (1 Viewer)

isladogs said:

Are you distributing your files as ACCDE files or using a professional installer package?
If the latter, you can include script to make the install location trusted. You can also purchase a certificate from Comodo or similar to ensure you are a trusted publisher. Doing that is expensive but it does mean your apps will not show unknown publisher warning messages.

Using self certification will not help overcome this issue.

Click to expand...

smig said:

Thanks
I'm using Inno Setup to install my App.
I'll look into scripting this.

Click to expand...

AccessBlaster said:

Also security certificates expire right?

Click to expand...

Galaxiom said:

Are your end users on your own domain?

Click to expand...

Pat Hartman said:

Are you running the app from a trusted folder? If not, you might want to try that first.

Click to expand...

isladogs said:

Are you distributing your files as ACCDE files or using a professional installer package?
If the latter, you can include script to make the install location trusted. You can also purchase a certificate from Comodo or similar to ensure you are a trusted publisher. Doing that is expensive but it does mean your apps will not show unknown publisher warning messages.

Using self certification will not help overcome this issue.

Click to expand...

smig said:

How do I set the install location trusted ?

Click to expand...

theDBguy said:

By adding an entry for it in the registry.

Click to expand...

smig said:

Thanks
Where exactly in the registry?
I remember I saw it before, but can't find it again

Click to expand...

theDBguy said:

Hi. Sorry, you beat me to it before I was able to add the link above. Please check my previous post again. I edited it to add a link. But just in case, here it is again.

Click to expand...

[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location]

isladogs said:

I recommend creating your own .reg file and saving the trusted location with a unique name specific to the location or app being trusted. For example:

Code:Copy to clipboard

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\MyTrustedAppPath]
"Path"="G:\\MyFiles\\ExampleDatabases\\MyTrustedAppName\\"
"AllowSubFolders"=dword:00000001
"Date"="25/07/2019 09:12:08"
"Description"="Your Description goes here ...."

TIP: If you export an existing trusted location as a .reg file its easy to use it as a template

Using this approach gives you more control over the registry entry.

It also allows you to add entries in one reg file for:
a) several locations at once
b) multiple Access versions if needed e.g. 12.0, 14.0,15.0,16.0.

NOTE: It doesn't matter if the user hasn't got all those versions or locations as anything irrelevant will be ignored.
In fact before A2019 was released I wrongly assumed it would be v17.0 and added trusted locations for that in advance. In the end none of those were required (as its still 16.0) but the extra entries aren't a problem

The attached reg file contains 2 sample entries for different locations for the 4 versions of Access listed above. Unzip, right click and select Edit from the context menu to view it in Notepad. Or right click and select Merge to add to registry.

Hope that helps

Click to expand...

smig said:

Thanks for the info
I had no Idea I can add a trusted location as Name instead of Location
Using Inno Setup App. it's easy to add registry entries. I'm sure will add entries for 14.0 and 16.0 (2013, 2016)
What is 15.0 ?

Click to expand...