Citrix Setup

I have a application that will be distributed using Citrix.  My client's IT support person set it up so that ALL users are sharing the same FE.  I asked him to change it but he doesn't know how so it seems to have fallen on me to find specific instructions for how to properly install Access in a Citrix environment.  All the articles I have found are old and none are specific.  I'm looking for a script if possible or a link to an article that explains what needs to be done.  I need to know how to copy the central version of the FE into each user's personal directory either at startup or when the user opens the app.  

The IT support person insists on running the app as an application and will NOT under any condition publish a desktop if that makes a difference.
LVL 41
PatHartmanAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
Yes, they are tokens.

The script is attached. It is slightly more complicated than you may need it, as it copies the master FE to two different local FE files and a shortcut from a distribution folder.
It will create the folder tree and also sets the necessary Registry entries to mark the local folder as a trusted location to Access.

Later, the user only has to double-click the shortcut to refresh the local copies of the FE and launch the primary FE which then silently launches the second copy which runs minimized.

It should be noted, that these users all have a full Office 2010 Pro install so no runtime install is needed.
RunPPT-Operations.vbs
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Pat,

 There are a couple of different ways to do this, but what you want is a path that is unique to each user and mapped at login.

  That can be done via a login script using %USERNAME% as part of the path, or through active directory.

So you might setup a directory structure like this:

\TSUserDirs
   \JDettman
   \PHartman

 and that get's mapped as drive "X".

 Now the app you publish is:

  X:\myApp.MDB

 and each user gets their own copy of the FE.    There is one gotcha here; unless you distribute individual copies, references you set in VBA are common.

 Say you have a library (MDA) and you've set a reference to it:

 C:\myApps\myMDA.MDA

 all users will be using the same MDA.   So you need to be careful in setting references.   Usually not a problem, as most references can be shared (like a DLL), but it's something to be aware of.

Jim.
0
 
Gustav BrockCIOCommented:
I have done this ... managed to get a FE at each user's desktop.

It's described here:

http://www.experts-exchange.com/Database/MS_Access/Q_28363614.html

I use a VB script, but PowerShell could be used as well I guess.

/gustav
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
PatHartmanAuthor Commented:
Gustav,
C:\Users\<username>\AppData\Local\<companyfolder>\<projectfolder>\<applicationfolder>
are the names inside the <> tokens?   Or do they need to be hardcoded for each user?
Can you post the script?

I have a batch file I use for installing on the LAN but in that case, everyone has the same script since the app is installed in a local directory with a fixed name.  

md c:\ClientMgt
del c:\ClientMgt\AOAClientManagement.accdb
copy \\newfiscal\Afox\AFox\AccessApplications\ClientMgt\AOAClientManagement.accdr c:\ClientMgt
c:\ClientMgt\AOAClientManagement.accdr

Open in new window


In Citrix, there won't be a local directory with a fixed name so how do I provide the correct name without having to create a separate script for each user?  I need to know how to refer to the "current user" and how to tokenize the command that executes the script.  I need one "script" that uses the username as a variable to get the database copied from the common folder to the user-specific folder.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<I need to know how to refer to the "current user">>

 %USERNAME% as I posted in my comment.

Jim.
0
 
PatHartmanAuthor Commented:
Looks exactly like what I need.
Thanks
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
All Courses

From novice to tech pro — start learning today.