when using SQL views, joining take place on the server which generally gives a better performance than locally by MSAccess queries. So you can replace your queries by SQLServer views and attach these as linked tables. Though there are some restrictions when you want to update.