You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column. (Error 3622)

Applies to: Access 2013 | Access 2016

The server-generated IDENTITY values cannot be reflected at the client side unless you use the DAO property dbSeeChanges.

See also