Error 3197 woes 
Author Message
 Error 3197 woes

I'm pretty new to database programming, but so far I've been able to
figure everything out, until this.  I'm writing a multi-user database
application in VB4.0 that uses Access 2 databases for storage (Although
I'm seriously considering purchasing a database server.) In this
program, each client continually (as often as possible with a timer
control) does a read from the database, and (less often) modifies it.

I keep getting an error 3197 ('Data has changed; Operstion Stopped')
when I try to use the Edit method on my database.  The help page for
this error says that it is caused when the table is modified by someone
else between your calling of 'Edit' and 'Update'.  This makes sense,
however in my case, I am sure that nothing else is changing this

I also looked on the Microsoft web page, and there was another
explanation for this error, that if a machine tries to modify the table
and does not have the most recent 'copy' (i.e. it has been changed by
another user and not yet refreshed), it will give the same error.  This
again makes sense, but does not apply to me since no other users are
changing it (although they do have it open).  Just to make sure,
however, I called the Refresh method of the recordset just before the
Edit method, and it didn't help.

So my question is, what other reasons are there for this error?  I
completely recreated the database that this error is occuring on, so I
know it's not corrupted.  If anyone has any ideas on this, I would
_greatly_ appreciate it; this problem is very frustrating.

Thanks in advance!


Technical Support               Home: (541) 928-4553
OSU Information Services Labs   Work: (541) 737-3384

Tue, 01 Sep 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Error 3197

2. Error 3197?

3. Run-Time Error 3197 - please help its driving me insane

4. Puzzling Error - 3197 - Jet Stopped Process?

5. error using recordset.edit method (3197)

6. recordset.edit method won't work (error 3197)

7. Error - 3197 - Please help

8. 3197 Error Updating an ODBC Datasource

9. Help. DAO 3197 error with single user

10. 3197 dao error

11. Error 3197 on a stand_alone pc

12. Error 3197 using SQL server


Powered by phpBB® Forum Software