Hi All
I have a query which I am trying to access from different computers on the network. On one of them computer it retrieves data very fast and rest of the computers on the network retrieves result from same query very slow.
Query fetch data from SQL server in Access 2007 and Access form show results return from query
I've checked following

1. Access query is similar which retrieves data from SQL Server on both computer (they are running same code)
2. I logged on to other computer which is fast and access same query and it was fast so I think user loggon is not issue.
3. Checking SQL profiler on my computer it is executing two extra query from order table which causes delay but this is not happening with access same query from other computer

Regards

I don't know why it's only running slowly from one computer and not the others. But here are some general considerations (excuse me if this is not new to you).

-Are you avoiding Access functions in the query? Using Access functions (such as Iif() and what not) can force the query to take multiple trips and slow things down
-Have you tried a pass-through query? You won't be able to alter data in the typcial Access way through pass-through queries (they are read-only), but if you can do this for a report or some unbound form, this could significantly improve the speed of a query. This can be some hassle to set up, but I think it's worth it.
-Just to make sure, is there any change in how the file is accessed between computers? Do some access the same file on a server, and one group run it locally on their own machines?

This happens when your computer needs formatting or some times it depends upon the browser you are using. The computers these days are of very high technology and some times this hig-tech things do not work so properly. As I had an issue with Mozilla6,that use to crash every now and then, but then I used Mozilla4, which is working perfectly fine. I think you might get the solution by trying these tiny things.