Solved

dbSeeChanges Error

Posted on 2014-01-21
3
213 Views
Last Modified: 2014-01-22
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
Comment
Question by:ICTIndika
3 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
This error appears when you open recordset that contains IDENTITY column.
see here: http://support.microsoft.com/kb/190620
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
Comment Utility
CurrentDB.OpenRecordset("myTable",dbOpendynamic,dbSeeChanges)

Jim.
0
 

Author Closing Comment

by:ICTIndika
Comment Utility
Thanks All.  I have applied the solution, and it worked just fine.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now