Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Location
    south jersey, usa
    Posts
    53

    Unanswered: edit live sql data?

    I have a sql express database with a couple tables of information. I have a user modifying one of these tables with a data access page using Office Web Controls.

    To backtrack a bit, the sql db used to be an access db. The same user modifying the data the same way. I also had a asp page making odbc calls to the access db to lookup information. But if the data access page was open, the odbc page would error. So i moved the data to sql.

    Now, I'm getting ready to setup an application to make odbc calls to the sql db. I still want the user to modify the data using the DAP. Should I allow the user to modify the live data used for the app or should I make a copy of the data everytime its updated?
    "They say Moses split the Red Sea
    I split the blunt and rolled the fat one, I'm deadly"
    -- Tupac 'Blasphemy'

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Shouldn't be necessary unless you have a large number of users accessing the data simultaneously. SQL Server's default locking should handle concurrency issues.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2006
    Location
    south jersey, usa
    Posts
    53
    that's what i wanted to hear.

    Cheers!
    "They say Moses split the Red Sea
    I split the blunt and rolled the fat one, I'm deadly"
    -- Tupac 'Blasphemy'

Posting Permissions

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