Posted by Erland Sommarskog on 10/29/07 08:14

Ben (pillars4@sbcglobal.net) writes:
> An update on this issue, I am still experiencing this slowness problem. I
> have tried from executing the maintenance processes, to checking the codes
> of the MS Access 2003 application.
>
> One new thing that we found is that if we access the MS Access application
> from one of the workstations via remote desktop, the speed is very fast.
> So, I do not know what is the relationship between remote desktop, the
> network, and SQL Serve 2005 and the application being faster or accessing
> the database faster.
>
> Does anyone have an idea?

Maybe you should involve people in the Access forums as well in case this is
an Access issue?

Given the low level of information you have provided, there is not really
much more to say from the SQL Server side. But I would recommend that you
investigate he query plans, and confirm that they are identical in all
cases.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]