jdasilva (5/5/2014)
Hello all,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...
In Sql Server, queries are called views, tables are of course tables but then you have all the things you do in modules, classes, functions and such in Access under the programmability tab in each database in Sql Server.
Many things are similar and for certain, if you can store the data in Access, you can store it in Sql Server. Play around with it and fire us a question when (if) you get stuck
😎