SharePoint Lists - Concurrency Issue

Question

Hi All,

I'm planning to use SharePoint lists in MOSS 2007. I need clarification reg. the concurrency issue with SP lists.
Assume If User 'A' updates a record in SharePoint and keep the browser open. Now user 'B' opens the lists and try update the record.

Will SharePoint locks the row for User 'B' or not? How to handle this issue?

My requirement is, When user 'B' opens the same record in Lists, he should be alerted with ReadOnly msgs.

- Sanra

Answer 1

hi...

well the example u gave might not result in concurrency ;-)

since user1 has made an update and window is open. user will see his change.
mean while when user 2 update the same record. user 2 will see his change. overwriting user1s change.
now untill unless user 1 refreshes his screen he will see his change and once refreshed user 2 chnages will be reflected.

does this answers to ur question?

---

ullasjoshi

Answer 2

Hi,

No. Let me rephrase my question.

When User 'A' opened a record for update (he didn't update yet) and opens the browser.

In a short while, User 'B' opens the same record, now User 'B' should be alerted with ReadOnly pop up or something to restrict from opening the record. I am expecting something similar edit feature in SharePoint library.

How to achieve this?


Regards
Sanra

Answer 3

When user B opens the same record, he will be able to make/commit changes at will. (I.e., the record will not be locked just because user A has it open on his machine).

If user A then attempts to modify the same record after user B modified it, Sharepoint will warn user A that he's modifying stale data that's been changed since he loaded it, and will give him a choices to manage the conflict (refresh, update, etc).

Answer 4

Good. But my users reported that SharePoint doesn't notify.

Is there any configuration settings for this?

Answer 5

for Custom list, there is no settings for it.
for Document Library, you can actually set the "Require documents to be checked out before they can be edited?" to Yes.

Cheers,
On3

Answer 6

Hi.

Is it possible to customize the Custom list to show "Require documents to be checked out before they can be edited?" using flag settings?

Pl. suggest a best possible way to achieve this.

Regards
Sanra