SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Wizard bronze trophy cydewaze's Avatar
    Join Date
    Jan 2006
    Location
    Merry Land, USA
    Posts
    1,096
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    MS SQL Server question

    My office is (finally) migrating from an MS Access database solution for our website to MS SQL Server.

    Currently, a lot of content owners update their pages by opening the MDB file in the Access desktop interface, then adding rows of data. My question is, with MS SQL Server, do you still have a database file that can be edited without the user knowing SQL (i.e. is there some sort of interface) or will there be some other way to update the data (like importing Excel files, or the old Access MDB files)?

    Other than Access, I only have MySQL experience, so I have no idea how MS SQL even works.
    <cfset myblog = "http://cydewaze.org/">

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,216
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by cydewaze View Post
    My question is, with MS SQL Server, do you still have a database file that can be edited without the user knowing SQL
    no
    Quote Originally Posted by cydewaze View Post
    I only have MySQL experience, so I have no idea how MS SQL even works.
    it works a lot like mysql, which has no file that you can open either
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,625
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    What you can do is "upsize" your existing access app to sql server and they might still be able to use the same UI now pointing at sql server. But access and MSSQL are very, very different beasts and I wouldn't expect the same tools and workflows to work necessarily.

  4. #4
    SitePoint Wizard bronze trophy cydewaze's Avatar
    Join Date
    Jan 2006
    Location
    Merry Land, USA
    Posts
    1,096
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    it works a lot like mysql, which has no file that you can open either
    I sort of figured that.


    Quote Originally Posted by wwb_99 View Post
    What you can do is "upsize" your existing access app to sql server and they might still be able to use the same UI now pointing at sql server. But access and MSSQL are very, very different beasts and I wouldn't expect the same tools and workflows to work necessarily.
    Yep, I knew about the upsizing, but I didn't know how involved it was, or if users could still maintain an Access MDB file that we could "upsize" as a way of importing.

    But your second sentence is a little spooky

    I also expect I'll have to "tweak" some of my web page queries, to "de-Access" them (like getting rid of those countless parens).
    <cfset myblog = "http://cydewaze.org/">

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,216
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by cydewaze View Post
    But your second sentence is a little spooky
    it's not really that difficult

    the parens can stay, and also the square brackets for delimiting table/column names

    some of the functions will need minor adjustment
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    357
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    You can use Access as a front-end client to ms sql server by creating an Access Data Project. You can use Access forms, reports, etc operating on your sql server database backend.
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon

  7. #7
    SitePoint Wizard bronze trophy cydewaze's Avatar
    Join Date
    Jan 2006
    Location
    Merry Land, USA
    Posts
    1,096
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    the parens can stay, and also the square brackets for delimiting table/column names
    I actually don't have any square brackets in my queries, so I think I'm in good shape.

    Quote Originally Posted by Doug G View Post
    You can use Access as a front-end client to ms sql server by creating an Access Data Project. You can use Access forms, reports, etc operating on your sql server database backend.
    Good info Doug, thanks.
    <cfset myblog = "http://cydewaze.org/">


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •