[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Citrix Setup

Posted on 2014-03-05
7
Medium Priority
?
794 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 58
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 52

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 39

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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

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

 %USERNAME% as I posted in my comment.

Jim.
0
 
LVL 52

Accepted Solution

by:
Gustav Brock earned 2000 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 39

Author Closing Comment

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

Expert Comment

by:Gustav Brock
ID: 39911775
You are welcome!

/gustav
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

650 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