lock the record at the time of updation.

See more:

VB

MS-Access

How to lock connection at the time of updation..
I install my sw on 3 pc. database is on server. sometimes records not get updated.. I want it lock the record at the time of updation.
this is my code....

con.BeginTrans()
strSQL = "Update indian set prfrnc='" & txtprfnc.Text & "' where MRN=" & txtmrn.Text & ""

con.Mode = ADODB.ConnectModeEnum.adModeShareDenyWrite
con.Execute(strSQL).LockType = ADODB.LockTypeEnum.adLockOptimistic
con.CommitTrans()


.