PRB: Error  3622  Open SQL Server Table with Identity Column
This article was previously published under Q190620
SYMPTOMS
When you try to open a Dynaset in Visual Data Manager (or Visual Basic sample 
project VisData) against a Microsoft SQL Server  6 . 5  table that contains an Identity 
column, you may receive the following error message: 
Error  3622  - You must use the dbSeeChanges option with OpenRecordset when 
accessing a SQL Server table that has an IDENTITY column. 
RESOLUTION
To work around this problem, set the Options property for the data control to 
dbSeeChanges ( 512 ). To change the Options property on a data control to the 
proper value, use one of the following two methods: 
-In the design environment, make sure that the data control is the selected item on 
your form. Then, go to the properties sheet, and set the Options property to  512 .
-In the run-time environment, use the following line of code to set the Options 
property of a data control named data1:
data1.options = dbSeeChanges