Sorry for a slow reply been away...

Probably the correct way is to use transactions. Not sure how to do it in an ADO command but maybe you can look into transactional commands in ADO like begin/end transaction. I recall you can do this.

Right now I use the lock table method (store a record in a table to indicate a lock, before you edit you check the lock table if the record is locked otherwise enter a record to lock)

HTH

>Hi Tim. Yes, I tried sending SELECT FOR UPDATE in an ADO command or by executing a procedure containing SELECT FOR UPDATE, and it works, but only while the command or procedure is executing. I am trying to find a way to lock a record from ADO, do some processing (with and without other ADO commands) then unlock the record when I am done.
>
>>Did you try:
>>
>>select columns from table_name for update