Unfortunately, Access queries use a different syntax, and in most cases other than action queries, are used as the basis for forms and reports. So you may be able to focus on just the update, append and delete queries - and they will generally need to be rewritten anyhow. If you are going to continue using an Access front-end, then using ODBC to link to the SQL Server tables, you may well not need to change the select queries. Bill Mitchell's comments are very pertinent too.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!