Tom Bolton
tom.bolton at donnslaw.co.uk
Wed Mar 23 10:13:02 CST 2005
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 & 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 -- 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...