Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,064

    Write Conflict

    I get this message when editing a record.



    Click image for larger version. 

Name:	Write Conflict.jpg 
Views:	24 
Size:	82.4 KB 
ID:	19018

    Since I'm still developing this DB There are no other user's other than me using the DB. The Data Fields are all in SQL Server only the forms, queries and reports are in MS Access 2010. What could be causing this error?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    This could be caused by a Form and a SubForm with similar RecordSources.

  3. #3
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,064
    No the main form is linked to tbl_Membership the subform is linked to tbl_Documents. The tbl_Documents does have a foreign Key to tbl_membership.

  4. #4
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Is there any VBA code that might change the same record (in the source table, not the form's recordset) that you are editing in the form?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Try using a QUERY of those table as a Recordsource instead of the tables directly.

  6. #6
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,064
    John, No there is no VBA in this DB at all yet.

    RuralGuy, I use tables as the data needs to be editable.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,389
    If you want to provide db for analysis, follow instructions at bottom of my post.

    Data can be edited via a simple SELECT query. However, I have doubt query as RecordSource will resolve the issue.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Queries are editable unless you do something weird.
    http://allenbrowne.com/ser-61.html

  9. #9
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,064
    RuralGuy, I'll try that today. Thanks

  10. #10
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,064
    Ok, made the record source of the main form and the subform queries based on the tables same result. That did not help whatsoever any other ideas? I am at a loss. I am going to try something will let you know in a bit.

  11. #11
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,647
    As June suggested, post a copy of the database with data to show the issue--remove anything confidential/private.

  12. #12
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    I'm afraid we're down to you zipping up your db and attaching it to a post. We're just shooting in the blind here.

  13. #13
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,064
    Okay I narrowed it down. the Tables are in SQL Server I was in the process of copying the tables to the local DB so I could post it and before posting I tested with the forms linked to the local tables it worked just as intended. So the issue has to do with the tables being linked from SQL Server. Posting the DB won't help because it works fine with the tables local.

  14. #14
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,011
    Do your Tables in SQL Server all have Primary Keys, or at least Unique Indexes, defined for them? Is the PK part of the RecordSource of the Form? These things not being true can cause many problems, including the inability to enter data. The fact that moving the Tables to the Front End resolves the problem tends to support this as being the root of the problem.

    BTW, Queries are editable, itís only multi-table Queries that are frequently non-editable.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  15. #15
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,064
    I thought they did but I double checked and no they do not. I put the Index on when linking but the source doesn't have the index. I'll fix that and retest thanks.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Write Conflict?
    By batowl in forum Forms
    Replies: 4
    Last Post: 11-13-2014, 12:38 PM
  2. Write Conflict Help
    By jbailey4545 in forum Access
    Replies: 5
    Last Post: 01-24-2014, 02:25 PM
  3. Write conflict
    By IslandHydro in forum Programming
    Replies: 4
    Last Post: 10-25-2013, 09:30 AM
  4. Write Conflict
    By sah in forum Forms
    Replies: 8
    Last Post: 04-25-2012, 07:19 AM
  5. write conflict error
    By karuppasamy in forum Access
    Replies: 1
    Last Post: 06-07-2011, 12:23 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