Question Multiple user editing same records..

[tang3li2]

Language: Visual Studio 2008 Pro
Database: SQL Server 2008

I have this question in my mind, that keep bugging me, after finishing writing my system.

I have this scenario that, what if there are two or three user that editing same records with time and seconds..

Example.
In my form i have Order Form which is has the records of client orders based on the Order_NO ( Fields [ auto increment ] )..

what if..

three users access that precise order form with same Order_NO and edit it, then save it!!

Question is, do you think is that a redundant process?? someone edit it, and also someone is editing it, and someone is editing it another with the same precise time..

I never find it so convinient though, is there someone can suggest anything on this kind of event?? i'm just new in vb.net..

Thank so much in advance..

 

[Ehsanit]

I assure you that it can and does happen. The solution is to lock a record while it is being edited so that only the one user can edit.

https://secure.wikimedia.org/wikipedia/en/wiki/Lock_(database)
Locking in the Database Engine

I'm not sure what code you'd use in VB though.