How to set macro security on distributed app

[bubba55]

I have a small app that I developed for a friend that allows him to track lab procedures. He does not have Access 2007 on his lab computer, so I installed the runtime. I then copied the app to his computer. Everytime I run the app, I get the message about macro security. I accept it and continue. How can I set the directory where the app resides as a trusted location. It is easy to do with a full copy, but I only have the runtime on his machine.

Thanks!

[pdebaets]

Open regedit and navigate to this registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted Locations\

Add a new key under "Trusted Locations". You can name it whatever you like. I suggest something like "MyCompany MyApp".

Under the new key, create a new string value called "Path". In the string value put the path to your application folder. Ex.: "C:\MyFolder\MySubfolder\"

If you want subfolders of your application path to be trusted as well, add a new DWORD value under your new key named "AllowSubfolders". Set the DWORD value to 1.

[bubba55]

I have searched through several books. I figured it was a registry key setting, but none have given me this info. I appreciate it!
THANKS AGAIN!

[edwardcga]

Open regedit and navigate to this registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted Locations\

Add a new key under "Trusted Locations". You can name it whatever you like. I suggest something like "MyCompany MyApp".

Under the new key, create a new string value called "Path". In the string value put the path to your application folder. Ex.: "C:\MyFolder\MySubfolder\"

If you want subfolders of your application path to be trusted as well, add a new DWORD value under your new key named "AllowSubfolders". Set the DWORD value to 1.

Is the above to be done on the machine with runtime installed (The User or client machine) Please advise.

EW

[pdebaets]

Is the above to be done on the machine with runtime installed (The User or client machine) Please advise.

EW

Yes.

Hope this helps

[amrut]

There is a utility here along with registry keys.
http://www.accessribbon.de/en/?Trust...sted_Locations