Re: pessimistic concurrency


"Tyler" <Tyler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E4072798-A8C8-4CEA-AF3C-A7B8735BAF5C@xxxxxxxxxxxxxxxx
Can anyone provide me with a good example or tutorial about pessimistic
concurrency? I have a simple table that 5 to 10 users will have to access
at
the same time. I will put a web form up so they can edit this data. I
don't
want to run into the chance that more than one will be editing the same
record at the same time. I will be using vb.net.

Is LockPessmistic good enough? The documentation says

adLockPessimistic:
Indicates pessimistic locking, record by record. The provider does what is
necessary to ensure successful editing of the records, usually by locking
records at the data source immediately after editing

Also the cursor location has to be server-sided for it to work

Stephen Howe



.