[AccessD] Access & 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
<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:14

> Hi Andy
>
> I've been building a complex Access app on TS (Win 2k) for Roz for some
> months now.  It's a reporting tool that connects to either Informix (boo)
or
> SQL Server (yay).
>
> Here are some of the problems I've come across:
>
> -- FE and BE in my case needed to be split as user info (saved queries
etc.)
> is stored in Access and we have ~12 'production' terminal servers.  These
> are load-balanced and users are kicked onto any one of them at random.  If
> no split, then the user needs to be on the same server they were on when
> they saved their data.
>
> -- Anything that dynamically alters queries etc.  needs to make a copy of
> these first to avoid locking issues.
>
> These are the biggies, otherwise everything seems to work/connect just as
in
> a normal client/server situation.  If you have specific questions I'd be
> more than happy to answer them as best I can.
>
> HTH
> Tom
>
>
>
>
> -----Original Message-----
> From: Andy Lacey [mailto:andy at minstersystems.co.uk]
> Sent: 23 March 2005 13:59
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access & Terminal Services
>
> Thanks Gustav, but the boss here is likely to want to go the TS route. We
> have Remote Control working nicely for him from home, but for lesser
> mortals, of whom there could be several, he doesn't want to have
> workstations dotted around which have to left on and not used by other
> workers, and other considerations. So I think TS would be right, but the
> question is whether everything that my app does (as outlined below) will
> work unaltered under TS.
>
> BTW what's the license cost implication of TS? Must be considerable if you
> went for an alternative. I thought it was part of W2000 server.
>
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
>
>
>
>
>
>
> 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