Need Help with Trust center using Access Run Time

[Jon123]

So I have been through as many of the posts I could find on this But I missing something. 1st off I can do the change manually but I will not and do not want any of my users in their resistory. That said I'm trying to get this note doc setup to create the trusted location.
This is the code I have so far.

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations]

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\FingerPrint]

"AllowSubfolders"=dword:00000001
"Path"="C:\Finger Print\"
"Description"="Finger Print program"
"Date"="05.01.2009 12:00"
[code\]

When this runs I get almost everything I'm shooting for but the Path.
The trusted location get added 
the date and desc. both get added
the allowsubfolders is correct 
but I cant seem to get the string value Path to work.

Any ideas or help please thanks for looking

jon

 

[Galaxiom]

Problem is you need two slashes in paths for registry entry strings (" blah\\blah")

This is the whole shebang for Access 2007:

[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\SomeName]
"Path"="[Drive]\\[Folder]\\"
"AllowSubfolders"=dword:00000001
"Description"="Some Description"

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"Level"=dword:00000001
"VBAWarnings"=dword:00000001

; required for accdb format
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines]
"SandBoxMode"=dword:00000002

; required for mdb format
[HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines]
"SandBoxMode"=dword:00000002

NOTE: Remove the spaces appearing in long lines such as in the word Access. They are an anomaly that appears in the post but not the edit window.

 

[Jon123]

ok got it working but I had to change it a little.
your code you had this

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted Locations]
[Code/]

If I use the path with the "A ccess" it creates everything in the registry but I still get the trust errors. If I change the code to "Access" then it updates the registry fine and the trust error are gone. So I guess my guestion is why are there 2 different security locations in the registry and how do you know what one to use?

thanks 

jon

 

[Galaxiom]

If I use the path with the "A ccess" it creates everything in the registry but I still get the trust errors. If I change the code to "Access" then it updates the registry fine and the trust error are gone. So I guess my guestion is why are there 2 different security locations in the registry and how do you know what one to use?

Must have been some formatting glitch that put the space in there when I pasted. I'll fix my post in case someone else comes across it. Will also fix the site specific name I left in what I posted. (Whoops)

First key allows network locations to be trusted.
Second key is to allow for a particular database
Third key lets VBA run without warnings.

The other two turn off sandbox mode which is designed to prevent more dangerous code from running. The code designed in Access is passed to a database engine (Jet or Access Conectivity Engine) to be processed so their settings need to be also changed.

I am not an expert at this stuff and found what to do by Googling.

There is stuff about sandbox mode here:

http://office.microsoft.com/en-us/access/HP010446591033.aspx

 

[Jon123]

I dont thik your code was wrong. look at this bmp
it shows both A ccess and Access ???

jon

 

[Galaxiom]

I would suggest deleting the A ccess key. It would have been written when you loaded the first registry key.

If you look at your original post you will see that your lines were similarly corrupted.
It is something odd about the forum as the space does not appear in the edit window.

Forums can do very odd things. I was on one recently where the word "specialise" in the edit window would appear as "none" when it was displayed on the forum. Makes adding an extra space seem minor.

 

[Jon123]

Got it. So I removed the A ccess key and all is now working. Thank you
this works great. The best part nobody needs to be poking around in the registry.

jon