When i add a new record to SQLServer using ADO i have a problem like this :
I m adding a new record to table and after updating i want to get the autonumber field of record that assigned by SQLServer. In my SQLServer thats working but in a different SQLServer not working. the code is like ..

open recordset with adopenkeyset and adlockoptimistic
addnew
.
..
.
.
.
update
variable = autonumber field
.
After updating i know that autonumber field will appear. But it doesnt apper. If i code movelast command after update thats also working but i dont want to use movelast.
If any one knows why such kind of thing happens please tell me.