Hi

Anyone knows how to detect there has been modified the record?


I am trying to develop a multi user application with VB6.
using ado with msacess
and I like to if there is a way to tell the user that the record they trying to update it has been modified another user

thanks :)

HI,

Well u can Lock the ADO recordset using AdloclPessimistic / AdLockOptimistic if u want to prevent clashesh in multi user. But if its your need to know if another user updated the record, u have to come with a little tricky way.

U can maintain a state variable in table itself and whenever a record is updated, update the state colum also. Whenever a user pick the recorset, he will pickup the state colum value. Anytime a user attempts to update, u compare the value of the state colum in recorset and table, if its same then no one has updated,else its updated......hope u got my point.

Gud luck

B. Anant

yes I thought of that but I was nont sure about it
Thanks
:)