Thanks, Stewart.....
Just so I'm clear - so I should be able to set up a blank Access database, then link to the SQL database via ODBC, run my queries in Access, and then save those queries in Access - i.e. use Access as my front end and not need to mess with designing queries in SQL.....the raw data remains in the SQL database.....do I have that right?