Andy Lacey
andy at minstersystems.co.uk
Wed Mar 23 08:55:28 CST 2005
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 & 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 > > -- > 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