>How can I lock the record using ADO. I want to lock the record before editing the record so that no other user can edit.

In this case you must use server-side cursor and set the LockType property of the recordset to adLockPessimistic. The record will be locked immediately after editing. Instead of Connection.Execute you will need to create Recordset object with desired properties, then use the Recordset.Open method to execute the query.