[AccessD] Access=>Termial Server=>SQL Server

MartyConnelly martyconnelly at shaw.ca
Fri Feb 2 20:13:19 CST 2007


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




More information about the AccessD mailing list