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,