Jim Lawrence
accessd at shaw.ca
Wed Mar 23 12:35:42 CST 2005
Hi Andy: That should work fine. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Wednesday, March 23, 2005 7:22 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Access & Terminal Services 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 & 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 &amp; 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 > > > > > > > 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