Re: [MS_AccessPros] seechanges

 

Terence-

You can safely use dbSeeChanges for either Access tables or a link to SQL Server.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 1, 2014, at 9:35 PM, <buffalome000@yahoo.com> <buffalome000@yahoo.com> wrote:

Folks, I am performing a conversion from MS acess 2007 to SQL server. I have encountered an issue with the option seeChanges. Under what circumstances is "seeChnages" required? and what does it do ?

 

Addtionally, If I use "seechanges" for SQL server, will it create a problem if I use the same statement in MS ACCESS 2007 ?

 

Below is a typical example:

 

Old statement

' below changed for SQL SEVER
Set rs = CurrentDb.OpenRecordset(mySql, dbOpenDynaset)

 

' below changed for SQL SEVER
Set rs = CurrentDb.OpenRecordset(mySql, dbOpenDynaset, dbSeeChanges)

 

TY

terence

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Recent Activity:

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___