Results 1 to 5 of 5
  1. #1
    IslandHydro is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Location
    Whidbey Island, Washington State, USA
    Posts
    21

    Write conflict

    Hello All,

    I'm brand new to this forum, so please be gentle if I'm asking a dumb question . I have a large access database (access 2010) where I often need to programmatically modify values for fields on the current form. I've tried modifying the control on the form directly through code, and this works but often triggers a write conflict error (another user has modified) when I move off the record. I think I've also tried update queries (modifying the underlying dataset directly rather than through the form). Worse than the error message, if I choose to overwrite it appears to corrupt the database! What's the right way to do this?



    Thanks,
    Doug

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    How does the DB appear to be corrupt? If you overwrite another user's changes, that record will be saved exactly like it looks on your current form.

    Perhaps overwriting another user's changes is breaking referential integrity rules. Is it really another user or do you have two forms open?

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Is this being used in a multi-user environment? If the answer is yes, is it split into a Front End/Back End configuration, with each user having a copy of the Front End on their hard drive?

    Linq ;0)>

  4. #4
    IslandHydro is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Location
    Whidbey Island, Washington State, USA
    Posts
    21
    Quote Originally Posted by ItsMe View Post
    How does the DB appear to be corrupt? If you overwrite another user's changes, that record will be saved exactly like it looks on your current form.

    Perhaps overwriting another user's changes is breaking referential integrity rules. Is it really another user or do you have two forms open?
    It is actually corrupt, in that data in fields that should be legible strings becomes gobbledeegook (that is the technical term) that looks like machine language code viewed in a text editor. When this happens I just have to go back and use a backup copy cause the database is screwed.

  5. #5
    IslandHydro is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Location
    Whidbey Island, Washington State, USA
    Posts
    21
    Quote Originally Posted by Missinglinq View Post
    Is this being used in a multi-user environment? If the answer is yes, is it split into a Front End/Back End configuration, with each user having a copy of the Front End on their hard drive?

    Linq ;0)>
    It is not really a multi-user environment although I do have it broken into a front and back end. There is one computer that keeps the live copy of the database, everyone else looks at a copy on their own local machine. The corruption seems to occur when I get the write conflict (another user has modified) error and I choose save.

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

Similar Threads

  1. write conflict error
    By nyneave in forum Security
    Replies: 1
    Last Post: 10-13-2012, 06:17 PM
  2. Write Conflict
    By sah in forum Forms
    Replies: 8
    Last Post: 04-25-2012, 07:19 AM
  3. Write Conflict Issues
    By AndrewsPanda in forum Access
    Replies: 2
    Last Post: 10-05-2011, 02:30 AM
  4. write conflict error
    By karuppasamy in forum Access
    Replies: 1
    Last Post: 06-07-2011, 12:23 PM
  5. Write Conflict Demonstration
    By pkstormy in forum Code Repository
    Replies: 1
    Last Post: 12-02-2010, 08:25 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