[AccessD] Citrix and Access

Dan,

  Probably the biggest issue when running under Citrix is that the "C" drive
is the same for everyone.  That's a bit of a problem where you want everyone
to have their own FE (which you would typically would install on their C
drive).  But there is an easy workaround for that; just map a unique path on
the server to a drive letter for their terminal services profile (something
like X) and place the FE there.

   A little more problematic however is references.  If you open up an FE,
you'll find all your references still pointing to C. For the most part, if
your just using the typical references, this is not an issue.  Those
references can be shared with no problem.

  But if your using a library reference (a reference to a MDA) or some type
of 3rd party component, then you might have issues with multiple users all
sharing that reference.  This is in fact the reason that some of the Wizards
in Office are not available under TS; they simply won't work when shared.

  Unfortunately there is not easy work around for this.  You have few
choices.  You can map the same drive letter for everyone (remote user or
not) and write your app against that or you can distribute two different
versions of the app (one that runs against C and one that runs against your
mapped drive letter).

  I've been lucky enough to only run up against this once, but when you do
it's a pain in the butt.

  Other then that, Access works wonderfully under TS/Citrix with JET or SQL
Server.

Jim.

   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, February 06, 2009 4:05 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Citrix and Access

Hi Arthur,

Anything you can think of that might have been restrictive or need to know?
I'll be switching out many users from running on their PC to using a Citrix
window.

Glad to hear about the response time!  Was your FE linked to SQL 2000 or
were you using an OLEDB Provider?

Thanks,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, February 06, 2009 2:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Citrix and Access

I have lots of experience running an Access app on Terminal Services, and
even with 70 users it was faster for me to develop on the remote TS box than
on my local machine at home. I was completely floored. Assuming a fast pipe
on both ends, I think you will be very pleased with the response time. (To
be fair, our Access back end was SQL 2000.)

hth,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com