dbSeeChanges Error

I have installed SQL- Express and I now get this error when opening a recordset.

You must use the dbseechanges option with OpenRecordset.  

Is there an example on how to use dbseechanges with the OpenRecordset?

Thanks
ICTIndikaAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
CurrentDB.OpenRecordset("myTable",dbOpendynamic,dbSeeChanges)

Jim.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This error appears when you open recordset that contains IDENTITY column.
see here: http://support.microsoft.com/kb/190620
0
 
ICTIndikaAuthor Commented:
Thanks All.  I have applied the solution, and it worked just fine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.