Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


New guy with a newbie question


New guy with a newbie question

Author
Message
jdasilva
jdasilva
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 62
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...
Eirikur Eiriksson
Eirikur Eiriksson
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6732 Visits: 17710
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
Cool
jdasilva
jdasilva
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 62
View is what I needed!

I am able to bypass the Access file (for the visio file to get the data) and it works the same for what I can see. I did have some issues with the SQL statement (it didn't seem to like my IIF statement, so I changed it to a case and it works) for a custom field in the query (was using the "wizard" gui in the SQL Studio at first, then edited the statement in the view).

I guess my next (ambisious) step is to move away from Access altogether and move it to a web app, or tie in to Share Point. They are now telling me that the data needs to be output to Share Point, but I have yet to work with that... don't worry about that for now, as I get rolling, I will post again.


Thanks for the insite!
Eirikur Eiriksson
Eirikur Eiriksson
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6732 Visits: 17710
Good stuff!
IIF is supported in Sql Server 2012 and later, my guess to aid portability from Access:-D
Good luck
Cool
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search