Link to home
Start Free TrialLog in
Avatar of PatHartman
PatHartmanFlag for United States of America

asked on

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.
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

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.
I have done this ... managed to get a FE at each user's desktop.

It's described here:

https://www.experts-exchange.com/questions/28363614/Access-Citrix-Instalation.html

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

/gustav
Avatar of PatHartman

ASKER

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.
<<I need to know how to refer to the "current user">>

 %USERNAME% as I posted in my comment.

Jim.
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Looks exactly like what I need.
Thanks
You are welcome!

/gustav