In many cases I find that the performance of queries that are using links to
MS SQL database have very good performance. In some cases stored procedures
are faster or have more capability.

I generally just use odbc to do the queries unless I am having a performance
problem. If I do have performance problems I will then look at alternative
solutions - pass through queries, stored procedures, etc.

I have tables in SQL server with millions of records and unless I do something
foolish (like return a million records) the performance is fine.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

inungh wrote:
My mdb file is moving tables from mdb backend to ODBC link to SQL
server tables, but queries are in the front end.

Should I change the queries to stored procedures to increase
performance or I can leave the queries in the front end mdb file that
the SQL server analyze the queries at server end even I have queries
in the front end?

Your information is great appreciated,