Results 1 to 5 of 5
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591

    Getting Write Conflict Errors when trying to save a record

    What seemed like a small task has turned out to be a major headache. The form pulls up and existing record to edit.

    Click image for larger version. 

Name:	Applicant1.JPG 
Views:	12 
Size:	23.0 KB 
ID:	44070

    The OnDirty event populates the initials and last updated fields.

    Click image for larger version. 

Name:	Applicant2.JPG 
Views:	12 
Size:	25.6 KB 
ID:	44071

    When I try to save the record I get the write conflict errors.

    Click image for larger version. 

Name:	Applicant3.JPG 
Views:	12 
Size:	27.4 KB 
ID:	44072

    Click image for larger version. 

Name:	Applicant4.JPG 
Views:	12 
Size:	24.3 KB 
ID:	44073

    I am the only person logged into this test environment. I cannot figure out why this is happening.



    Any ideas?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    what is your actual setup (FE/BE located where?)? how are you saving the record? by leaving the record? running some code? Have you had a crash recently that closed the app? Have you tried rebooting?

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    What's the code in your OnDirty event?

  4. #4
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    Ha! It turned out to be, as a suspected, a small error that was easily fixed.
    I was logged into the wrong SQL Server BE (Dev) which I don't have write access to, instead of Test, which I do.
    Ajax reply got me to relink all my tables, but this time to Test. The record now saves correctly. The Write Conflict error message sent me down the wrong rabbit hole.


    davegri: Here's the On Dirty event, but now its a moot point.

    Code:
     
    Private Sub Form_Dirty(Cancel As Integer)
        Me.UserID = gblInitials
        Me.LastUpdated = Format(Date + Time(), "mm/dd/yy hh:mm")
    End Sub
    Thanks to you both for lending a hand.

  5. #5
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Oh well, stuff happens. Good you go it working.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Write Conflict.
    By Homegrownandy in forum Forms
    Replies: 5
    Last Post: 05-18-2017, 05:29 PM
  2. Replies: 4
    Last Post: 09-23-2015, 09:30 AM
  3. Write conflict errors and how to manage
    By Ruegen in forum Access
    Replies: 10
    Last Post: 11-21-2013, 06:22 PM
  4. Write Conflict
    By sah in forum Forms
    Replies: 8
    Last Post: 04-25-2012, 07:19 AM
  5. Write Conflict Errors with SQL-Access DB
    By trb5016 in forum Access
    Replies: 5
    Last Post: 01-14-2010, 02:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums