Access => Termial Server => SQL Server

[LonnieJohnson]

Hello all,

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?


ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[jsteph]

It runs slow alot.

Lonnie,
You've really got to be more specific. Also, run it from the console and take terminal server out of the picture to eliminate TS lag for percieved slow response. Are there local tables involved also, or a pure front-end?
--Jim

 

[Remou]

This thread provides some general advice:
Producing database advice
thread669-1323229

And may help you in answering jsteph's questions.

 

[LonnieJohnson]

Thanks jsteph,

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 a network version of MyDocuments. We have a dual terminal server that tries to balance the load of users.

We also have another set of users that do not use T-Server and are not having this problem.

I am just shooting in the dark here hoping someone has had simular problems.

Thanks again.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!