I currently have an Access 2000 application running in a client/server

configuration. Access is both the client and the server. I'm using linked

tables in the client and the performance is dismal. I know that the Jet is

moving all the data across the network and then running the query on the

client.



My forms and reports are all tied to queries. Is there some way of forcing

Access to run the queries on the server in order to improve performance?



Also, I'm considering migrating to SQL Server in order to get the queries

running on the server. Would this result in a significant increase in

performance?



Sincerely, 



Orlando Rodriguez

Hello Orlando, 



   I've been for the last month working on the issue that you have at hand.  

As far as I know there is no way to force Access to run queries on the 

server side.  What I have done is linked my Access tables to an SQL 

environment, by doing this you will be dealing with Access Projects (ADP) 

and you will have to design Views(Queries) and Stored Procedures that run 

on the server side which make your database more efficient.  I'm new at 

this and what I have done is purchased the following book, published by 

Wrox and there is a discussion group on this website, the book is:



Professional SQL Server Development with Access 2000 by Rick Dobson



this book has been great help and explains many of the problems that you 

will encounter.



As a matter of fact, I received a couple of responses from the author of 

this books solving some of the basic problems I found which were query 

referencing from forms, and parameters on queries.



Any question feel free to e-mail me, 

millos21@h...



Suerte,



Cesar Henao





















> I currently have an Access 2000 application running in a client/server

> configuration. Access is both the client and the server. I'm using linked

> tables in the client and the performance is dismal. I know that the Jet is

> moving all the data across the network and then running the query on the

> client.

> 

> My forms and reports are all tied to queries. Is there some way of forcing

> Access to run the queries on the server in order to improve performance?

> 

> Also, I'm considering migrating to SQL Server in order to get the queries

> running on the server. Would this result in a significant increase in

> performance?

> 

> Sincerely, 

> 

> Orlando Rodriguez