Hi, I'm developing a multi user application in VB6 using a database
connection with ADO. I would like to use transactions using BeginTrans
method and actually I'm not able to lock a recordset when it is under
editing.
Why I could open a recordset from a PC while another user is editing the
same recordset from another PC?
I have open the recordset with pessimistic lock and I expect to get an error
message when 2 or more user try to modify the same record.

What can I do to detect locking on recordset?

  dbConn.CursorLocation = adUseServer
  dbConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=data.mdb;"
  dbConn.Open
  rsDestinatari.ActiveConnection = dbConn
  rsDestinatari.CursorType = adOpenDynamic
  rsDestinatari.LockType = adLockPessimistic
  rsDestinatari.Open "Select * from Poeple"

Tanks

Andrea