Lonnie Johnson
prodevmg at yahoo.com
Sat Feb 3 08:04:50 CST 2007
Thanks Marty, Some of the links did not exist any more but there was some other interesting information that was sort of unrelated that was helpful. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: MartyConnelly <martyconnelly at shaw.ca> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Friday, February 2, 2007 8:13:19 PM Subject: Re: [AccessD] Access=>Termial Server=>SQL Server Maybe some hints here http://www.granite.ab.ca/access/terminalserver.htm Are you running full licensed SQL Server 2000 Lonnie Johnson wrote: >Thanks William, > >I know the possibilities are enormous because we have three different areas and the network that transmits them. > >This is an Access front end with linked SQL Server tables that are bound to forms. Each user has their own copy of the app in their network version of MyDocuments. We have a dual terminal server that tries to balance the load of users. > >I am just shooting in the dark here hoping someone has had simular problems. > >Thanks again. > > > > > > > > > >May God bless you beyond your imagination! >Lonnie Johnson >ProDev, Professional Development of MS Access Databases >Visit me at ==> http://www.prodev.us > > > > > > > > > > >----- Original Message ---- >From: William Hindman <wdhindman at dejpolsystems.com> >To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> >Sent: Friday, February 2, 2007 4:10:10 PM >Subject: Re: [AccessD] Access=>Termial Server=>SQL Server > > >Lonnie > >...first question is your configuration ...do you have a single Access fe >with all ts users hitting it or a separate copy installed in each user's ts >directory with only that user using that fe copy ...the single Access fe >will definitely slow as the number of users increase. > >William Hindman > >----- Original Message ----- >From: "Lonnie Johnson" <prodevmg at yahoo.com> >To: "AccessD solving'" <accessd at databaseadvisors.com> >Sent: Friday, February 02, 2007 1:14 PM >Subject: [AccessD] Access=>Termial Server=>SQL Server > > > > >>I have an access app that runs on a terminal server and uses SQL Server as >>a back end. It runs slow alot. >> >>I was wondering if there were any tips on performance? >> >> >> >> >> >> >> >> >> >>May God bless you beyond your imagination! >>Lonnie Johnson >>ProDev, Professional Development of MS Access Databases >>Visit me at ==> http://www.prodev.us >> >> >> >>____________________________________________________________________________________ >>Never miss an email again! >>Yahoo! Toolbar alerts you the instant new Mail arrives. >>http://tools.search.yahoo.com/toolbar/features/mail/ >>-- >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >> >> > > > > > -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ____________________________________________________________________________________ Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index