Slow Query times with SQL Server

[homeguard]

I have an access database frontend with a SQL Server backend, the backend is located in Kansas City and the frontend is on a users desktop in Cali. It takes forever for the server to run some simple querys, is there a better way to do this so it doesnt take so long?

What i think the problem is that i have linked the tables and put query in the access front end, so when the user wants to query it has pull that entire table to the users and then run the query on it, is there a way to make access push the query to the server and have the server run it then give the results back?

 

[pbaldy]

Generally Access will try to have the server process the query and only send back the results, but some things can prevent it. You can use stored procedures to force the issue. Here are some other thoughts:

http://www.sql-server-performance.com/tips/access_sql_p1.aspx

 

[homeguard]

hmm ok thanks for the infos