[Issue] Auto-increment columns are not updated until the record is updated. [Cause and Resolution] 
Cause: After calling RecordSet.AddNew in Jet, the auto increment column is available before the record is updated. This is not true in SQL Server or SQL Azure. The new value of the identity column new value is available only after saving the new record. Resolution: Run the following Visual Basic for Applications (VBA) code before accessing the identity field: Copy Recordset.Update Recordset.Move 0, Recordset.LastModified