title | keywords | f1_keywords | ms.assetid | ms.date | ms.localizationpriority | |
---|---|---|---|---|---|---|
You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column. (Error 3622) |
jeterr40.chm5003622 |
|
fba44d14-39c0-f507-fe6e-7d0df911ece9 |
06/08/2017 |
medium |
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.
- Access for developers forum
- Access help on support.office.com
- Access help on answers.microsoft.com
- Access forums on UtterAccess
- Access developer and VBA programming help center (FMS)
- Access posts on StackOverflow
[!includeSupport and feedback]