Hi!
Have you specified oRS.CursorLocation = adUseServer when trying oRS.LockType = adLockPessimistic ?

Alexander

>I'm trying to write a routine to generate ID's, based on a meta table, which will control my ID's... Well, I'll open a RecordSet with the record that brings me the last ID for a given table, and I want to increment that ID and update on my table. Well, while I'm doing this process, I must lock the record, this way no user will generate the same ID.
>In VFP, that's easy... but with ADO, I just don't know how to do that... I'm trying oRS.LockType = adLockPessimistic, but it doesn't works.