I've got a problem on updating my Disconnected Recordset. If I update a field
which is specified as a type of identity column in the database, then it
always failed. I got an error: "Multiple-step operation generated code errors.
check each status value"

For example, I've got a table named MyTable with three columns (A,B,C). I
set Column A as identity column. Then I code my disconnected rs as follows:

Dim RS as ADODB.Recordset

set RS = new Recordset
RS.cursorLocation = adUseClient
RS.open "SELECT A,B,C FROM MyTable",MyDSN,adOpenStatic,adLockOptimistic
set RS.ActiveConnection = nothing

'** try to Add new
RS.Fields("A") = 123
RS.Fields("B") = "bla"
RS.Fields("C") = "bla"

Either add new or just update would always fail. If I remove identity from
column A then it runs smoothly, What's wrong here??

Is there any workaround for this? BTW, I'm using MDAC 2.7

Thanks for any help