This seems to be tricky

I am doing a Updatebatch through ADODB.Recordset. The table to which I am doing an insert has an Identity Column.
After Update gets over,an arbid value is returned for the Identity Column

For ex -

Identity Column had a Value of 1000 before Adding a new record
After AddNew,the recordset has something like 3042 instead of 1001

Is this a known problem in ADO and RDS ?

Thanks
Anand