>>>I'm trying to get an server side ADO Recordset from an Oracle table with the LockType = adLockPessimistic, but it does not work. Can I not do this with Oracle?
>>
>>Also, word of warning. If another user has any one of the records you want locked, you will be in a wait state until the lock[s] is released. I know there is an additional clause to prevent this.
>>
>>FOR UPDATE NOWAIT
>>
>>I am at DevCon and I do not have my Oracle ref books, and I am not sure of the exact clause.
>
>
>Thanks. When I used 'FOR UPDATE' in the Recordset Source I get no records being returned.

Sorry, I have no experience with ADO recordsets yet. So I do not know what is happening. There may be an interpretation problem by ADO of that FOR UPDATE clause. Do you get an error? Does AERROR() return any error information?