• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

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
0
ICTIndika
Asked:
ICTIndika
1 Solution
 
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
CurrentDB.OpenRecordset("myTable",dbOpendynamic,dbSeeChanges)

Jim.
0
 
ICTIndikaAuthor Commented:
Thanks All.  I have applied the solution, and it worked just fine.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now