Digital Certificates

[austinp3515]

Developed database in Access 2013 but running in Access 2013 runtime. I need to have the macro warning suppressed. Can anyone tell me a) where to get the digtial certificate for the cheapest price and then b) how to roll it out?

 

[isladogs]

I use a Comodo certificate purchased from KSign - approx £80 per year?
They will provide instructions on how to use it.

However, that alone won't stop security warnings.
You will need to make the database location trusted.
You can't do that in the runtime version itself
Instead, add the location to the registry

The code below can be adapted to suit your setup - modify the path etc as appropriate:

//trusted locations
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location10 :: Path="C:\Programs\MendipDataSystems\"
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location10 :: AllowSubFolders=1
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location10 :: Description="Mendip Data Systems"
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location10 :: Date="08/12/2015 19:51"

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location10 :: Path="C:\Programs\MendipDataSystems\"
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location10 :: AllowSubFolders=1
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location10 :: Description="Mendip Data Systems"
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location10 :: Date="27/04/2014 19:51"

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Access\Security\Trusted Locations\Location10 :: Path="C:\Programs\MendipDataSystems\"
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Access\Security\Trusted Locations\Location10 :: AllowSubFolders=1
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Access\Security\Trusted Locations\Location10 :: Description="Mendip Data Systems"
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Access\Security\Trusted Locations\Location10 :: Date="27/04/2014 19:51"

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location11 :: Path="C:\Programs\MendipDataSystems\"
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location11 :: AllowSubFolders=1
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location11 :: Description="Mendip Data Systems"
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location11 :: Date="08/12/2015 19:51"

Version 15.0 is Access 2013

 

[austinp3515]

Thatls a bit over my head.... That's really unfortunate that its so complicated...

 

[isladogs]

Thatls a bit over my head.... That's really unfortunate that its so complicated...

Google - Add trusted locations in Access

 

[austinp3515]

I tried that already, no luck. I didn;t think that option existed for Runtime. Is that accurate?

 

[isladogs]

It works if you edit the registry as I said before.

 

[austinp3515]

I don;t doubt you for a second, but you're likely multiples my senior when it comes to windows! I'm sure if I did what you suggested, and some other problem came up, if our IT people heard I did THIS they would be horrified.

 

[isladogs]

I don;t doubt you for a second, but you're likely multiples my senior when it comes to windows! I'm sure if I did what you suggested, and some other problem came up, if our IT people heard I did THIS they would be horrified.

Quite possibly.
If it helps, I include script to edit the registry with the EXE file used to install my distributed databases. It happens 'silently'

If you tell me the folder your access file is saved in, I can write you a registry script as a simple text file. It will take about a second to run and is perfectly safe.

 

[austinp3515]

PArdon me Ridders, but I am a proper lady and this is just our first date

 

[isladogs]

PArdon me Ridders, but I am a proper lady and this is just our first date

Damn ... My charms are clearly not what they once were ....

 

[Galaxiom]

if our IT people heard I did THIS they would be horrified.

Talk to your IT people about what you need.

If you are on a domain they should be able to manage the who thing through Group Policy.