I can lock a record connecting to SQL Server 7.0 using a pessimistic lock 

and openkeyset as the cursor.



my problem is when somebody else tries to read this record,  I set the 

connection CommandTimeout, which if it times out should generate an error 

(according to Wrox ADO 2.6 and API documentation)but I can't trap this 

error.



Has anybody any ideas, or am I missing something?



Cheers,