Results 1 to 6 of 6
  1. #1
    swenger is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    144

    issue modifying a record with write conflict

    Just a bit of background which may help find a solution to my problem. I had this access database for a very long time and about a year ago i moved the back end to an SQL server. I ran into this problem before where when i add a new field to a table it puts a NULL value in all the previous records and then i get a message "Write conflict". So i ran a query to update all the records to 0. However i am still having a problem where i can create new records and i am also able to go into any previous records (30,000 plus) that were created before i added this field and i can edit them. However any new records that i create once i leave that record and then go back to it to modify i get this write conflict.

    Thanks,


    Sam
    Attached Thumbnails Attached Thumbnails conflict.png  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,364
    it usu happens when 2 people edit the same record.
    But i've had it on me alone, on a single non shared db, due to 2 forms both accessing the same record, thus conflict.

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    3,625
    This is a known problem with Bit fields in SQL server; make sure you set the bit field to not allow nulls and set its default value as required (=0 but sometimes =1 depending on your needs).
    https://stackoverflow.com/questions/...write-conflict
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,570
    @Gicu's answer was spot on for your particular issue. For more details, see my article Write Conflict Errors (isladogs.co.uk)
    Colin, MVP 2022, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    swenger is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    144
    That worked. Thanks everyone.

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    3,625
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 4
    Last Post: 01-29-2021, 01:19 PM
  2. Write Conflict.
    By Homegrownandy in forum Forms
    Replies: 5
    Last Post: 05-18-2017, 05:29 PM
  3. Write Conflict
    By RayMilhon in forum Forms
    Replies: 16
    Last Post: 12-12-2014, 10:31 AM
  4. Write Conflict?
    By batowl in forum Forms
    Replies: 4
    Last Post: 11-13-2014, 12:38 PM
  5. Write Conflict
    By sah in forum Forms
    Replies: 8
    Last Post: 04-25-2012, 07:19 AM

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