VBA, Run time error 3622: OpenRecordSet: SQL server table: IDENTITY column

Run time error 3622: OpenRecordSet: SQL server table: IDENTITY column

Author	Message
Christ M #1 / 2	Run time error 3622: OpenRecordSet: SQL server table: IDENTITY column When my code runs to the following statament, an error message pops up: Set rcsScanedRackList = dbsCurrent.OpenRecordset("dbo_ScanedRackList", , dbSeeChanges) ---------------------------------------------------------------- Run time error 3622 You must use the dbSeeChanges option with OpenRecordset when accessing a SQL server table that has an IDENTITY column. ---------------------------------------------------------------- Just as you see, I've use the dbSeeChanges option. But the error still occurs. Why? Can you help me? Thanks in advance.
Sun, 29 Apr 2001 03:00:00 GMT

Rodic #2 / 2	Run time error 3622: OpenRecordSet: SQL server table: IDENTITY column Maybe you don't close the recordset after you use it. Before End Sub try : .... rcsScanedRackList .Close End Sub Rodica Quote: >When my code runs to the following statament, an error message pops up: >Set rcsScanedRackList = dbsCurrent.OpenRecordset("dbo_ScanedRackList", , >dbSeeChanges) >---------------------------------------------------------------- >Run time error 3622 >You must use the dbSeeChanges option with OpenRecordset when accessing a SQL >server table that has an IDENTITY column. >---------------------------------------------------------------- >Just as you see, I've use the dbSeeChanges option. But the error still >occurs. Why? >Can you help me? Thanks in advance.
Sat, 05 May 2001 03:00:00 GMT

Page 1 of 1

[ 2 post ]