Use SQL stored procedure or Access query?

[maacky99]

We are using an Access front end and connecting via OBDC to SQL Server 2000.

My question is this - currently all of our queries are in Access and hitting the SQL database for data. Should I be using stored procedures via SQL Server or keep doing what we're doing? It seems like we are moving pretty slow since we 'upgraded' to the SQL back end and I thought this might help.

 

[FoFa]

Stored procedures or views, but mostly stored procedures.
What this does is run the selection criteria on the SQL server and only moves the selected data across the network instead of all the data, typically. If you change to an ADP it is suppose to do that for you and optimize it all.