Multiuser Issue

[cjimloo]

Hi Guys,

Do yours have any idea how to design a application which is fully multiuser?

Application Platform : VB.NET
Database Server : SQL Server 2000 and MSDE

Note: Thats mean if one of the record in table is being edit by user 1, it cannot view or edit for tat record by another users.

 

[a_jam_sandwich]

Easiest way is to add a column to your table LOCK when a record is being edited LOCK will contain the UserID

When user has updated record LOCK is set to Null again

All you need do now is when Editing check if LOCK is set if it is you can even say whos editing it if not edit the record.

Andy

 

[hog]

probably not exectly whet you are after, but using optimistic concurrency will stop one user overwriting another users changes