Record Locking

[Brandon]

We just tested a multi-user application. We ran (3) applications at the
same time and accessed the same table. 

V4rb - Windows XP - vSERVER
------------------
CLIENT A
Sql = "Select * from Test WHERE RecID=1"
Cur = app.mdb.SQLSelect(Sql, EVCursorLocation.kServerSide,
EVLockType.kReadWrite)
No error - all is well!
------------------
CLIENT B
Sql = "Select * from Test WHERE RecID=1"
Cur = app.mdb.SQLSelect(Sql, EVCursorLocation.kServerSide,
EVLockType.kReadWrite)
Error occurs - record is locked - great! This is what we expected.
------------------
CLIENT C
Sql = "DELETE FROM Test WHERE RecID=1"
Res = app.mdb.SQLExecute(sql)
No error? Record is deleted! We thought it was locked by Client A?
------------------

QUESTION:  If record is currently locked by Client A, can another client
still delete it?

Thanks,

Brandon