locked
Restrict editing of items in a list to a single user at a time RRS feed

  • Question

  • I have an item in a list.  How can I restrict this item from being overwritten by two users at the same time?

    Some background:

    - Windows SharePoint Services 3.0 SBS Server 2008
    - List with 100 columns; each item in the list has a 100 columns of data
    - Simultaneous edits to an item overwrite each other

    - User A opens an item in the list
    - User B opens the same item
    - User B makes change and closes the item
    - User A makes other changes and closes the item without knowing that user B has modified the item
    - Result:  User A's changes are reflected but user B's changes are lost

    Thursday, February 9, 2012 1:45 AM

Answers

  • Hello,

    Enable versioning in your list. So, whenever a user edits an item it will be created as seperate version.

    Go to List Settings - > Versioning Settings -> Create a version each time you edit an item in this list? - Make this YES and click on OK


    Ram Prasad Meenavalli | MCTS SharePoint 2010 | MCPD SharePoint 2010

    Thursday, February 9, 2012 7:12 AM

All replies

  • Create an Event handler for Item Updating to check whether any user is updating the item or not.  This link might help you in creating the  Event Handler

    http://msdn.microsoft.com/en-us/library/ms453149.aspx

    Please check this post similar to this
    http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/a77fc085-b9d0-4654-8d3d-2756ab51bc47
    • Edited by SivaMit Thursday, February 9, 2012 6:40 AM
    Thursday, February 9, 2012 6:37 AM
  • Hello,

    Enable versioning in your list. So, whenever a user edits an item it will be created as seperate version.

    Go to List Settings - > Versioning Settings -> Create a version each time you edit an item in this list? - Make this YES and click on OK


    Ram Prasad Meenavalli | MCTS SharePoint 2010 | MCPD SharePoint 2010

    Thursday, February 9, 2012 7:12 AM
  • There is a SBS forum for questions from SBS users.

    This seems to be something that could also apply to WSS 3.0 running under Windows so I'm letting it stay here. But as soon as you have questions about companyweb or things like network problems affected by the SBS aspect, please post them to the SBS forum.

    Moderator pre-SP 2010 forums


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters

    Thursday, February 9, 2012 8:58 AM
  • This worked!  Ram P Meenavalli provided the quickest way to achieve the results needed.  I have tested using "Versioning" and it does throw "Save Conflicts" just as desired.  Understood Mike Walsh, I felt this was a total WSS issue, not SBS, thanks for letting this stay.  Our organization is greatly appreciative and will save vital info that was mysteriously being lost.
    Thursday, February 9, 2012 2:00 PM