Article ID: 190620
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.
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:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
You need to recompile VisData.vbp, create a new VisData.exe, and then copy it to the VisualBasic default folder.
You can modify the VisData sample to avoid the error. There are two places that you need to make the changes: where you open a recordset from the Database Window, and where you execute a SQL statement.
WARNING: ANY USE BY YOU OF THE CODE MODIFICATIONS PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this code modification "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. Microsoft does not support modifications to sample applications or tools.
Article ID: 190620 - Last Review: June 22, 2014 - Revision: 3.0