Roz Clarke
roz.clarke at donnslaw.co.uk
Wed Mar 23 09:42:27 CST 2005
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 -------------- next part -------------- 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...