record check!

[patdev]

Hi all,

How would i know if the record is locked or not before perfroming any operation!! and user cannot perform any update on it but can view it while other user is making the changes!?

thanks

[erickwidya]

using .editmode property of the recordset

from MSDN

adEditNone - Indicates that no editing operation is in progress.
adEditInProgress - Indicates that data in the current record has been modified but not saved.
adEditAdd - Indicates that the AddNew method has been called, and the current record in the copy buffer is a new record that has not been saved in the database.
adEditDelete - Indicates that the current record has been deleted.