>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.
>
>Anybody can tell me? By the way Im using vfpoledb.1 provider.

You'll have to create server side cursor with LockType = adLockPessimistic.