Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yossibaram
Yak Posting Veteran
82 Posts |
 Posted - 2002-11-04 : 04:27:50
|
| Hi,I have a dilemma regards an access to data by more then one user in MSDE.Most of my SP are planned to access the db and when the work is done the connection is terminated.I have a GUI the shows detailes of a product. the form enables you to modify the data of that product in the db. To enable more then 8 users working simultanusly (what MSDE allows) I'm openning and closing connections as the work is done on the db (not the form).I have a problem in the following scenario:User A opens Product form and do changes to Product AA.Before User A updates the db User B make some changes to the same product AA. One of the updates will be lost.Can i,let say mark a record for a period of time so another user that will try to access that record will get notification that this record is currently in use?I hope I'm clear enough.Thanksyossi |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-11-04 : 05:11:05
|
| You are referring to subject that's as old as client - server applications. The catch is in record locking, which MS in general (ADO-MSSQL) does not support anymore. If you're using ADO, optimistic record locking is the right way to go.I suggest you read a book about ADO. You'll find lots of interresting examples of how to solve your problem.... |
 |
|
|
|
|
|
Sharing data dilema