Solved

Citrix Setup

Posted on 2014-03-05
7
738 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 35

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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 35

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

815 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now