I have 2 connections to the same database which both have the following properties:
Mode = adModeShareExclusive and IsolationLevel = adXactReadCommitted;

I then run a "SELECT * FROM TABLE_A FOR UPDATE" query for each connection by creating a recordset with a dynamic cursor and pessimistic locking in an attempt to generate some kind of an error stating that the resource is locked so I can handle it as I wish. Unfortunately, this actually succeeds and the only error I can generate is a "time out" when trying to move through the record sets using MoveFirst, etc.

Does anyone know of a way that I can exclusively lock a record when performing an SQL statement so that it causes an error when another connection/user tries to access it(read or write)? Any information would be greatly appreciated.

I can be e-mailed at atrolio@erggroup.com if you would rather not post to this forum.

Kind regards,
AT.