[AccessD] Access & Terminal Services

Andy Lacey andy at minstersystems.co.uk
Wed Mar 23 09:21:33 CST 2005


Ouch, ouch, ouch. My optimism has just gone out the window. My Access app
relies heavily on the FE being dynamic and personal to the user - all sorts
of queries being created/updated, temp tables etc. Couldn't contemplate a
rewrite. How can I get round this? What's to stop me creating a folder on
the server for each user, putting a copy of the FE in each, and having each
run their own? I don't have the foggiest idea what I mean when I say "each
run their own" in the context of TS, but does that work?

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: RE: [AccessD] Access & Terminal Services
Date: 23/03/05 16:15

> Hi Andy
>
> What Roz is saying is that if there are three users on a terminal server,
> and each of the three opens your Access app, they are using the same one.
> If (on a non-TS network) you had your app stored on a network drive, and
> three users opened it simultaneously, it would be exactly the same.
>
> If one of the users (whether on TS or normal network) altered one of the
FE
> objects (querydef, table) you would have locking issues.  It is best,
then,
> to make a copy of that object in your FE and alter the copy.  This is what
> I've had to do.  Unfortunately, altering a report puts the FE into
exclusive
> lock so this is unachievable with TS unless each user has a copy of the
FE.
>
> HTH - sorry, I was about to explain myself better but got caught up and R.
> beat me to it.
>
> Cheers
> Tom
>
>
>
> -----Original Message-----
> From: Andy Lacey [mailto:andy at minstersystems.co.uk]
> Sent: 23 March 2005 14:55
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Access & Terminal Services
>
> Hi Roz,
> My ignorance here is total, so please bear with me. I envisaged that each
> user would be totally separate on TS, and hence would have a separate FE.
> Are you saying that's a choice I need to be careful to make at some point
> when setting-up?
>
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
>
> --------- Original Message --------
> From: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> To: 'Access Developers discussion and problem solving'
> <accessd at databaseadvisors.com>
> Subject: RE: [AccessD] Access & Terminal Services
> Date: 23/03/05 15:42
>
> > Hi Andy
> >
> > Queries in the FE are only OK if you have 1 user per TS or you make a
copy
> > of your FE per user - we have up to 30 users per server and at the
moment
> > they are all accessing a single FE install on each server, so the FE
is
> > shared.
> >
> > We're considering going the FE-per-user route as we're going to have
to
> > start making run-time changes to report objects any time now. On our
setup
> > it's not straight forward but if you're starting small and working up
it
> > should be OK for you.
> >
> > Roz
> >
> > -----Original Message-----
> > From: Andy Lacey [mailto:andy at minstersystems.co.uk]
> > Sent: 23 March 2005 14:23
> > To: Access Developers discussion and problem solving
> > Subject: RE: [AccessD] Access &amp; Terminal Services
> >
> >
> > Thanks Tom
> > I'm ok with point 1 but I was alarmed by your 2nd point. Then I
thought
> that
> > you must mean dynamically altering queries in the BE. Am I right?
Surely
> > queries in the FE are ok.
> > --
> > Andy Lacey
> > http://www.minstersystems.co.uk
> >
> >
> >
> > --------- Original Message --------
> > From: Access Developers discussion and problem solving
> > &lt;accessd at databaseadvisors.com&gt;
> > To: 'Access Developers discussion and problem solving'
> > &lt;accessd at databaseadvisors.com&gt;
> > Subject: RE: [AccessD] Access &amp; Terminal Services
> > Date: 23/03/05 15:14
> >
> > &gt; Hi Andy
> > &gt;
> > &gt; I've been building a complex Access app on TS (Win 2k) for
Roz for
> > &gt; some months now.  It's a reporting tool that connects to
either
> > &gt; Informix (boo)
> > or
> > &gt; SQL Server (yay).
> > &gt;
> > &gt; Here are some of the problems I've come across:
> > &gt;
> > &gt; -- FE and BE in my case needed to be split as user info
(saved
> queries
> > etc.)
> > &gt; is stored in Access and we have ~12 'production' terminal
servers.
> > &gt; These are load-balanced and users are kicked onto any one of
them at
> > &gt; random.  If no split, then the user needs to be on the same
server
> > &gt; they were on when they saved their data.
> > &gt;
> > &gt; -- Anything that dynamically alters queries etc.  needs to
make a
> copy
> > &gt; of these first to avoid locking issues.
> > &gt;
> > &gt; These are the biggies, otherwise everything seems to
work/connect
> just
> > &gt; as
> > in
> > &gt; a normal client/server situation.  If you have specific
questions I'd
> > &gt; be more than happy to answer them as best I can.
> > &gt;
> > &gt; HTH
> > &gt; Tom
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt; -----Original Message-----
> > &gt; From: Andy Lacey [mailto:andy at minstersystems.co.uk]
> > &gt; Sent: 23 March 2005 13:59
> > &gt; To: Access Developers discussion and problem solving
> > &gt; Subject: Re: [AccessD] Access &amp;amp; Terminal
Services
> > &gt;
> > &gt; Thanks Gustav, but the boss here is likely to want to go the
TS
> route.
> > &gt; We have Remote Control working nicely for him from home, but
for
> > &gt; lesser mortals, of whom there could be several, he doesn't
want to
> > &gt; have workstations dotted around which have to left on and
not used by
> > &gt; other workers, and other considerations. So I think TS would
be
> right,
> > &gt; but the question is whether everything that my app does (as
outlined
> > &gt; below) will work unaltered under TS.
> > &gt;
> > &gt; BTW what's the license cost implication of TS? Must be
considerable
> if
> > &gt; you went for an alternative. I thought it was part of W2000
server.
> > &gt;
> > &gt; --
> > &gt; Andy Lacey
> > &gt; http://www.minstersystems.co.uk
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt; The contents of this message and any attachments are the
property of
> > &gt; Donns
> > Solicitors
> > &gt; and are intended for the confidential use of the named
recipient
> only.
> > They may be legally
> > &gt;  privileged and should not be communicated to, or relied
upon, by any
> > other party without
> > &gt; our written consent.  If you are not the addressee, please
notify us
> > immediately so that we
> > &gt; can make arrangements for its return.  You should not show
this
> e-mail
> > &gt; to
> > any person or
> > &gt;  take copies as you may be committing a criminal or civil
offence for
> > which you may be
> > &gt;  liable.  The statement and opinions expressed in this
e-mail message
> > &gt; are
> > those of the
> > &gt; writer, and do not necessarily represent that of Donns
Solicitors.
> > Although any files attached
> > &gt;  to this e-mail will have been checked with virus protection
software
> > prior to transmission,
> > &gt; you should carry out your own virus check before opening any
> > &gt; attachment. Donns Solicitors does not accept any liability
for any
> > &gt; damage or loss
> > which may be caused
> > &gt; by software viruses...
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt;
> > &gt; --
> > &gt; AccessD mailing list
> > &gt; AccessD at databaseadvisors.com
> > &gt; http://databaseadvisors.com/mailman/listinfo/accessd
> > &gt; Website: http://www.databaseadvisors.com
> > &gt;
> >
> > ________________________________________________
> > Message sent using UebiMiau 2.7.2
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> >
> >
> >
> > The contents of this message and any attachments are the property of
Donns
> Solicitors
> > and are intended for the confidential use of the named recipient
only.
> They may be legally
> >  privileged and should not be communicated to, or relied upon, by any
> other party without
> > our written consent.  If you are not the addressee, please notify us
> immediately so that we
> > can make arrangements for its return.  You should not show this
e-mail to
> any person or
> >  take copies as you may be committing a criminal or civil offence for
> which you may be
> >  liable.  The statement and opinions expressed in this e-mail message
are
> those of the
> > writer, and do not necessarily represent that of Donns Solicitors.
> Although any files attached
> >  to this e-mail will have been checked with virus protection software
> prior to transmission,
> > you should carry out your own virus check before opening any
attachment.
> > Donns Solicitors does not accept any liability for any damage or loss
> which may be caused
> > by software viruses...
> >
> >
> >
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> ________________________________________________
> Message sent using UebiMiau 2.7.2
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>
> The contents of this message and any attachments are the property of Donns
Solicitors
> and are intended for the confidential use of the named recipient only. 
They may be legally
>  privileged and should not be communicated to, or relied upon, by any
other party without
> our written consent.  If you are not the addressee, please notify us
immediately so that we
> can make arrangements for its return.  You should not show this e-mail to
any person or
>  take copies as you may be committing a criminal or civil offence for
which you may be
>  liable.  The statement and opinions expressed in this e-mail message are
those of the
> writer, and do not necessarily represent that of Donns Solicitors. 
Although any files attached
>  to this e-mail will have been checked with virus protection software
prior to transmission,
> you should carry out your own virus check before opening any attachment.
> Donns Solicitors does not accept any liability for any damage or loss
which may be caused
> by software viruses...
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list