I got following error message when I migrate my MS Access backend to
SQL Server backend.
Once I added dbSeeChanges option, the programs works.
The only thing is that I had dbFailOnError option which does not allow
me to have 2 options.
Is it possible to have dbFailOnError and dnSeeChanges 2 optins
together, because I want to the application stop when any errors
during open recordset.
Your help is great appreciated,
You must use the dbSeeChanges option with OpenRecordSet when
accessing a SQL Server table that has an IDENTITY column
Copyright © 2001-2012 GNT Media