>Actual error message is: 3251, object or provider is not capable of performing requested operation. I do not need to edit the Oracle, just the recordset so report shows more info. Thanks.
>
>>I've asked this in other forums and not getting response.
>>
>>So, I am using Oracle with ADO open method inputting the params for optimistic, dynamic cursor. The data is there, but I need to edit four fields before printing a report.
>>
>>rstWO!user_1="aaa"
>>nor
>>rstWO.fields("user_1").value="aaa"
>>work to change the data, as I get error something like:
>>'task can't be accomplished'
>>then I would do an:
>>rstWO.update if I got past the edit line.
>>
>>Any ideas?

You might want to try a different type of cursor, like a client side static one: Cursorlocation = 3 (adUseClient), CursorType = 3 (adOpenStatic).