Not getting err 3197: Data has changed 
Author Message
 Not getting err 3197: Data has changed

In developing a multi-user application using VB 3.0/prof edition, Access 2.0
with the service pack installed, and the compatability layer, I have discovered
that error 3197, data has changed, is not being generated when attempting to
apply the edit method to a record in a dynaset whose underlying data has been
changed by another user.  I'm seeing this behaviour in both network operations
(WFW 3.11) and in stand-alone operation (two instances of same app. running).
Has anyone experienced this problem?  Or is there something I'm just not
understanding?  BTW, I'm using pessamistic locking.

Richard from Santa Fe

Sat, 08 Nov 1997 03:00:00 GMT  
 Not getting err 3197: Data has changed


>that error 3197, data has changed, is not being generated when attempting to

I am sure you are right.  I remember reading this error in the
KnowledgeBase.  Check there to see if there is a workaround.

The KB is on

If you can't get that tell me and I will try and help you.


Tue, 11 Nov 1997 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. error 3197: data has changed

2. Data has changed error 3197

3. Problem w/ Data has changed Error #3197

4. Need help Re: Possible Causes For 3197 - Data Has Changed - Operation Stopped

5. Error 3197 - Data has changed, operation stopped - singleuser

6. Getting error 3197 "Data has changed - operation stopped"

7. DAO err 3197 Instead of "Data Locked"

8. Having trouble getting the Alias (Account) field data from a global address

9. Help - Simply Getting Data from Extrenal Data Files (not from Access Data Base)

10. VB3 Err - Data Has Changed

11. Data error event hit err:Column(ordernr)does not exist in the appropriate rowset

12. What is Error: 3197 Data has changed operation stopped?


Powered by phpBB® Forum Software