Visual Basic For Applications: You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column

Platform:Visual Basic For Applications
Task:You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column
Discussion:
You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column
Example:
Set rs = query.OpenRecordset(dbOpenDynaset, dbSeeChanges) 
Back to Index