Setting Trusted Locations with VBA

[Paul H]

See post #3

I read post #3, but it didn't sink in. My developer friend straightened me out and wrote a .reg file for me.

Now the .bat calls the .reg file and everything works like clockwork.

"C:\FITS\reg\FITS.reg"

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\FITSLocation0]
"Path"="C:\\FITS\\"
"Description"="FITS Location"
"Date"="02/18/2020 05:00 AM"


[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\FITSLocation0]
"Path"="C:\\FITS\\"
"Description"="FITS Location"
"Date"="02/18/2020 05:00 AM"

Thanks to everybody that played.

Paul

[isladogs]

Excellent.
If you want to save your own reg file, open Regedit, right click on a key you want to reuse/modify for future use and click Export.
This will create your own .reg file for future use.

BTW - you might want to include subfolders in the trusted location. For example:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location0]
"Path"="C:\\PROGRAMS\\MENDIPDATASYSTEMS\\"
"AllowSubfolders"=dword:00000001
"Description"="Mendip Data Systems folder"
"Date"="15/12/2016 23:27"

The value 00000001 means True

[wjfinnigan]

I'm going to go ahead and show my age here.

I'm still packaging using the Access 2010 package function. I really wish it was still available in the current versions, however I've found that even though it properly adds the registry key including the database directory and a description, it is still poping up the error.

On the code I'm using I've tried creating a location 9 and using the old standard I used to use of my initials. However both of them create registry keys in the trusted location but I still see the errors. My keys are getting created properly, but I'm still getting the errors. Do I need to include date, or additionally add network locations using the dword:00000001 ?

I'm left scratching my head here. My registry keys look correct, but I'm still getting the popups.

-John