I get Error 3197 while entering data in new record on a subform

[Guest]

Access 2002-Using a Access 2000 database
Stand alone database
A single user gets error 3197 multiple times when trying to enter data on a
new record autogenerating within a subform. The users enters data into one
or more fields, leaves the subform and tries to move to the next record in
the main form. After clicking through multiple error msgs, the next main
form record is displayed. Upon return to the previous mainform record, she
finds that the subform information was updated. Once this happens, it will
always happen for that session.
It does not seem to occur for the first instance of data entry during a new
session but it will with the second entry. Other users with the same
original database don't have the problem, but will encounter it if they use a
copy of the problem mdb..

 

[Guest]

Hi Kate,

I've recieved this error on a couple of my clients's databases. It appears
that the error is related to corruption in the underlying data tables,
probably in a memo field. The best I've managed to come up with is the
following work around which works *most* but not all of the time:

on all the subforms---add this code to the subform's error event:
=======================================
Private Sub Form_Error(DataErr As Integer, Response As Integer)
'this is the only thing that bypasses this error. NS 12/23/02
If DataErr = 3197 Then
'MsgBox "RIS Debug-Dependent subform!", , DataErr
Me.Parent.Refresh
Response = acDataErrContinue
End If

Hope that helps,

Carl