I have an Access 2007 application with linked tables to sql server 2005. Many
of the users will run Access 2007 Runtime.

The sql server and Access client is continuously updated. New access 2007
clients need to be re-distributed quite often. The users are warned there is
a newer client (Access 2007) available and are told to download a newer
version to their workstation, preferably to a trusted location.

I feel removal of an old Access 2007 Runtime client and installation of a
new via control panel Add/remove programs is too slow and complicated because
re-distribution will happen quite often. I would like the users to download a
new file, unpack it and simply click on it to get started. I hope to avoid
using the installation package.

The application runs on an intranet with mainly windows xp workstations
without access installed (only Access 2007 Runtime). How can I create the
trusted location for these users?

Regards from

Tore

The Runtime cannot create Trusted Locations so you must do it with a
registry file. Here's one:
------------------------------------------------
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\MyApp]
"Path"="C:\\MyApp"
"AllowSubfolders"=dword:00000001
"Description"="My trusted location"
------------------------------------------------

Name the above something like:

Trusted.reg

and run it once from the desktop. Then delete it. Users will need admin
permissions on their machine to run it.

Another possiblitity, and one which is designed for your application is Tony
Toews AutoFE Updater

http://autofeupdater.com/

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

You can thank the FTC of the USA for making this disclaimer necessary.


"Tore" <(E-Mail Removed)> wrote in message
news:8DA65FBD-A8A1-4957-97E3-(E-Mail Removed)...
>I have an Access 2007 application with linked tables to sql server 2005.
>Many
> of the users will run Access 2007 Runtime.
>
> The sql server and Access client is continuously updated. New access 2007
> clients need to be re-distributed quite often. The users are warned there
> is
> a newer client (Access 2007) available and are told to download a newer
> version to their workstation, preferably to a trusted location.
>
> I feel removal of an old Access 2007 Runtime client and installation of a
> new via control panel Add/remove programs is too slow and complicated
> because
> re-distribution will happen quite often. I would like the users to
> download a
> new file, unpack it and simply click on it to get started. I hope to avoid
> using the installation package.
>
> The application runs on an intranet with mainly windows xp workstations
> without access installed (only Access 2007 Runtime). How can I create the
> trusted location for these users?
>
> Regards from
>
> Tore

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote:

>The Runtime cannot create Trusted Locations so you must do it with a
>registry file. Here's one:
>------------------------------------------------
>Windows Registry Editor Version 5.00
>
>[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
>Locations\MyApp]
>"Path"="C:\\MyApp"

Trouble is if the location is a user specific location, such as
Application Data, then it gets rather ugly to distribute a registry
file.

>Users will need admin
>permissions on their machine to run it.

Not sure about a registry file but they don't need admin permissions
to update HKCU registry entries. Otherwise my Auto FE Updater
couldn't update those.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

Thank you for responses. Is not at all possible to create a trusted location
for a local administrator via control panel, computer management etc? I had
hoped I could have instructed the users how to do it.

I dont want any user to edit the registry on their workstation. My users are
not gurus, and I dont have much experience with registry editing myself. I
guess folder structures will be different from one pc to the next.

Regards from Tore

Hi Tore,
Unfortunately there is no Windows UI that can help you on this without
installing Office Designer components. I recommend that you develop a
Windows application as a client tool to help the customer do this. In your
application, you can code to modify the registry keys. What your customer
need to do is just double clicking your application and specifying a
trusted location by himself/herself. Of course, you can provide a default
location in your application for convenience.

Best regards,
Charles Wang

It is easier than that. Put the following, just as it is here in a Notepad
text file:

******************Start Code*******************************

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\MyApp]
"Path"="C:\\MyApp"
"AllowSubfolders"=dword:00000001

*****************End Code*********************************

Leave out the Start and End Code lines and watch out for line wrapping. Save
the file as something like:

Trusted.reg

Now have your users double-click on it. You are done. If your email system
doesn't allow you to email .reg files, simply change the extension top .txt
and have them change it back to .reg to run it. They can delete the file
when they are done. It is not rocket science. A 5th grader can do it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Tore" <(E-Mail Removed)> wrote in message
news:6FB6A28B-1C10-4109-BD29-(E-Mail Removed)...
> Thank you for responses. Is not at all possible to create a trusted
> location
> for a local administrator via control panel, computer management etc? I
> had
> hoped I could have instructed the users how to do it.
>
> I dont want any user to edit the registry on their workstation. My users
> are
> not gurus, and I dont have much experience with registry editing myself. I
> guess folder structures will be different from one pc to the next.
>
> Regards from Tore