Opening access form on different computers - dissimilar process time RRS feed

  • Question

  • 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



    Thursday, August 11, 2011 9:41 AM