[MS_AccessPros] seechanges

 

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 (1)

Recent Activity:

Visit Your Group

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

.

__,_._,___