Update rs not working

[riarc]

I am updating my recordset and for some reason I keep getting and error msg. Can anybody see anything wrong with this?
My rs is open and it is an Optimistic


With rstCustomerInfo
.Fields("l_name&quot = txtLastName.Text
.Fields("f_name&quot = txtFirstName.Text
.Update
End With

 

[MatDavies]

What cursortype are you using?

Try .CursorType = adOpenDynamic

might help.


Mat

 

[riarc]

I tried that. The error msg I get is a run time error.
"Multiple step operation generated error."
Cusror location is client side.

 

[MatDavies]

What Database/Diver are you using?

 

[riarc]

I am using SQL server 7. I was returning my rs from a stored procedure but for some reason it wouldn't allow me to update the rs. So I put the sql in my Utility and opened the rs that way.
Here is the exact err_msg
"Multiple step OLE DB operation generated errors. check each OLE DB status value if available.

 

[MatDavies]

All I can think of is that it may not be an updatable query. You could try a work around by directly updateing the table seperatly when you know what infomation needs updating.

sorry, maybe someone else can shed some light on the matter

Mat

 

[riarc]

Thanks for the help.