PRB: Error 3622 Open SQL Server Table with Identity Column (190620)
The information in this article applies to:
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
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:
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 10/15/2002 |
---|
Keywords: | kbBug kbDatabase kbDSupport kbprb KB190620 |
---|
|