Solved

Citrix Setup

Posted on 2014-03-05
7
749 Views
Last Modified: 2014-03-06
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.
0
Comment
Question by:PatHartman
  • 3
  • 2
  • 2
7 Comments
 
LVL 57
ID: 39906938
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
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39907693
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
 
LVL 36

Author Comment

by:PatHartman
ID: 39907819
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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 57
ID: 39908090
<<I need to know how to refer to the "current user">>

 %USERNAME% as I posted in my comment.

Jim.
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39908691
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
 
LVL 36

Author Closing Comment

by:PatHartman
ID: 39909736
Looks exactly like what I need.
Thanks
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39911775
You are welcome!

/gustav
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question