Tags Tags

You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column

October 13th, 2011 - 03:34 pm ET by iccsi | Report spam
Help Create a new topic
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
email Follow the discussionReplies 1 replyReplies Make a reply

Similar topics

Replies

#1 John W. Vinson
October 13th, 2011 - 05:06 pm ET | Report spam
On Thu, 13 Oct 2011 12:34:15 -0700 (PDT), iccsi wrote:

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



These flags are bitmapped: dbFailOnError is 128, dbSeeChanges is 512. So you
can pass them both together by just adding them:

DoCmd.OpenRecordset ..., dbSeeChanges + dbFailOnError

You can even add other flags such as dbAppendOnly or dbDenyRead etc. in the
same way.


John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Fo...accessdev/
http://social.answers.microsoft.com...US/addbuz/
and see also http://www.utteraccess.com
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search