need help with a reg edit bat file

[Jon123]

I used to use this code to create modify the registry so that every user would just have to click on a simple bat file to run my dbase without getting the security warnings. I just need to add this dir to the trust center
"C:\USERS\PUBLIC\DESKTOP\WETCLEANS\"
I don't want users to have to modify this themselfs. Any ideas on how to update the trust center using a bat file?

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations]
"AllowNetworkLocations"=dword:00000001
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Wetcleans]
"Path"="c:\\Wetcleans\\" 
"AllowSubfolders"=dword:00000001
"Description"="Part Tracker dbase"
"Date"="05.01.2009 12:00"
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"Level"=dword:00000001
"VBAWarnings"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\ Access Connectivity Engine\Engines]
"SandBoxMode"=dword:00000002

 

[Galaxiom]

reg.exe can be run from a bat or cmd file.

However I would not recommend putting your database folder directly in the root of the drive. Even less would I want to see a database folder on the desktop.

The user's AppData folder is better and will have the right permissions. It can be addressed with environment variables.

 

[gemma-the-husky]

it might be that you cannot modify the trust settings other than from the environment. if you could, it would leave a bit of a whole in the security system.

I think I have seen this point made elsewhere.

 

[Jon123]

The folder on the desktop is a place that the database puts a datafile that gets emailed out at the end of their shift. So what happens in the flow of things. Many users will enter data all shift long and at the end of a shift a lead will send out a shift report. I have made it so that the shift report in automatically generated and dumped into a folder on the C:\USERS\PUBLIC\DESKTOP\WETCLEANS\ folder. So all they do is go into their email and attach this file for their update. (Simple for management to see status) it all works fine but if the C:\USERS\PUBLIC\DESKTOP\WETCLEANS\ is not set as a trusted location then it generates the error msg. I would just perfer sending an emil with a simple .bat file out to everyone and have that update their trust center. That would be better then me doing it on everyone's pc but if that is the only way to update it then so be it.