Results 1 to 7 of 7
  1. #1
    stalk is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    May 2014
    Posts
    143

    Write Conflit error- identified the issue with checkbox but cannot fix it?

    I have 3 records with null values in the check boxes, when I try to update these checkboxes to zero , update query is not working as a result when I try to update these records it is giving me write conflict error.

    Is there a way to update my check boxes to zero to prevent the write conflict error?




    Thank you

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if the checkboxes are assigned to Boolean fields, they are already true or false (0). there should be no nulls.

    did you run an update query on the record?
    is the check box bound to a boolean field?

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Is this a split database with a sql server backend database?
    If so, go through each table in the BE and make sure every Boolean field has a default value
    Update any existing nulls as necessary.
    The issue will be solved.

    If it's Access I would still ensure you set a default value for Boolean fields
    Colin, Access MVP, 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

  4. #4
    stalk is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    May 2014
    Posts
    143
    I spent lot of time on updating the back end SQL table to set the checkboxes to zero. but it did not work so I copied the 3 records to a temp table , deleted them from main table and re-inserted them into the main table by setting the check boxes to zero. It just took 5 minutes to delete and reinsert; compared to 1 hour spending on update query.

    Thank you for taking time to responding.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You're welcome.
    So have you now set the defaults on all boolean fields in the SQL server tables?
    Colin, Access MVP, 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

  6. #6
    stalk is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    May 2014
    Posts
    143
    The two bit fields were created as not null, so they are causing the problem. In the Access form I them to have default values as zero. Hopefully when a new record is entered it will not have any problem.

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Set the default values where the data is stored. In sql server, not Access
    Colin, Access MVP, 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

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

Similar Threads

  1. Write Conflict By Checkbox In Continuous Form
    By Wappervliegje in forum Access
    Replies: 9
    Last Post: 11-14-2017, 04:49 AM
  2. write conflict error
    By nyneave in forum Security
    Replies: 1
    Last Post: 10-13-2012, 06:17 PM
  3. write conflict error
    By karuppasamy in forum Access
    Replies: 1
    Last Post: 06-07-2011, 12:23 PM
  4. Replies: 1
    Last Post: 02-27-2011, 06:50 AM
  5. Write Conflict Error
    By botts121 in forum Access
    Replies: 5
    Last Post: 09-25-2009, 12:11 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