troubleshooting Question

Response = acDataErrContinue, etc. with write conflict

Avatar of Mike Eghtebas
Mike EghtebasFlag for United States of America asked on
Microsoft Access
9 Comments1 Solution3134 ViewsLast Modified:
With a write-conflict case in my application in order to suppress "Write Conflic" popup, I am using the attached code.

On the popup form, I was getting three buttons like:

[Save Record]    [Copy to Clipboard]    [Drop Changes]    '<--- with these three buttons

It seems, Response = acDataErrContinue in the code is the same as clicking on [Copy to Clipboard].

Question: What are the constants for the other two buttons. Mostly, I am interested in the constant for [Drop Changes]?

Thank you.

Private Sub Form_Error(DataErr As Integer, Response As Integer)
    Response = acDataErrContinue
    Select Case DataErr
    Case 7787, 7878    'Write conflict errors - multi system / network usage only.
        Response = acDataErrContinue
        ' Me.Undo   'optional
    Case Else
        MsgBox "An unexpected error has occurred. The error number is:" & Chr(13) & Chr(13) & DataErr, 16, Me.Caption
    End Select
End Sub
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros