Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-17-2019, 12:05 AM   #16
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,063
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: remove the "Unknown Publisher" security warning

Quote:
Originally Posted by theDBguy View Post
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.
Thanks
How can I make sure not to overwrite existing trusted location ?
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\A ccess\Security\Trusted Locations\Location(n)]

smig is offline   Reply With Quote
Old 11-17-2019, 03:50 AM   #17
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,369
Thanks: 115
Thanked 3,111 Times in 2,829 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: remove the "Unknown Publisher" security warning

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:
[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
Attached Files
File Type: zip MyTrustedLocationsExample.zip (600 Bytes, 6 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
smig (11-17-2019)
Old 11-17-2019, 06:29 AM   #18
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,063
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: remove the "Unknown Publisher" security warning

Quote:
Originally Posted by isladogs View Post
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:
[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
Thanks for the info
I had no Idea I can add a trusted location as Name instead of Location(n)
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 ?

smig is offline   Reply With Quote
Old 11-17-2019, 07:46 AM   #19
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,459 Times in 1,440 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: remove the "Unknown Publisher" security warning

Quote:
Originally Posted by smig View Post
Thanks for the info
I had no Idea I can add a trusted location as Name instead of Location(n)
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 ?
So, I think it's:

2007 = 12.0
2010 = 14.0
2013 = 15.0
2016 = 16.0

There was no 13.0
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
smig (11-17-2019)
Old 11-17-2019, 08:25 AM   #20
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,369
Thanks: 115
Thanked 3,111 Times in 2,829 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: remove the "Unknown Publisher" security warning

The scripting in Inno is doing exactly the same thing.
Note the double backslashes in folder paths for the reg entries.

You can also remove entries using script and, if you want, use hex values rather than text
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
smig (11-17-2019)
Old 11-17-2019, 10:31 PM   #21
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,063
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: remove the "Unknown Publisher" security warning

I saw there is another security section
Security\Trusted\Documents\Trust\Records
What it is?
Do I have to set it too,and how ?
smig is offline   Reply With Quote
Old 11-17-2019, 10:41 PM   #22
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,459 Times in 1,440 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: remove the "Unknown Publisher" security warning

Quote:
Originally Posted by smig View Post
I saw there is another security section
Security\Trusted\Documents\Trust\Records
What it is?
Do I have to set it too,and how ?
Just setting Trusted Locations should be good enough.


__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
smig (11-18-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
have any way to disable "Security Warning" ? Dlovan-IT Modules & VBA 13 10-11-2013 07:04 AM
Disable security warning to "enable content"? Heatshiver General 11 01-08-2012 08:38 AM
Issue in Access database "Windows Security Warning " aman Modules & VBA 1 06-15-2011 02:26 AM
How to programmatically disable the "Security Warning" screen? accesser General 5 12-02-2010 01:01 PM
"unknown publisher" since installing SP2 robjones23 General 7 05-23-2007 08:00 AM




All times are GMT -8. The time now is 12:32 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World