I've played around with Access and SQL statements for some time, not a master by any means, but the data I am storing has gotten to the point where we have had to move it to an SQL server (sharing the data across many offices).
At this time, the data stores information that is called up by a visio floor plan. Right now, I have an Access front end that creates the query putting information together from a couple of tables for what the Visio floor plan needs. I was thinking, would it not be better to have the SQL server run the query?
If I am on the right track, then here I am. I have created the Query (poking around in SQL Server Managment Studio), but this is not like access where there is a section for Tables, Queries, Ect. It seems that Queries are saved as project files? how would I have my Visio linked data find the query? In visio, using the connection wizard, I can see the tables...