Results 1 to 6 of 6

Thread: Write conflict

  1. #1
    Join Date
    Jan 2003
    Location
    Guelph, Canada
    Posts
    39

    Unanswered: Write conflict

    I'm currently receiving the error msg. below as I close a report.

    "This record has been changed by another user since you started
    editing it. If you save the record you will overwrite the changes the
    other user made."

    "Copying the changes to the clipboard will let you look at the values
    the other user entered and then paste your changes back in if you
    decide to make changes."

    " SAVE RECORD COPY TO CLIPBOARD DROP CHANGES "


    I have an On Close event procedure for the report as follows:

    Forms!MenuBeth!Check11 = True
    Forms!MenuMain!Check7 = True
    Forms!MenuBeth.Refresh
    Forms!MenuMain.Refresh

    I added the refresh statements as recommended by another in an
    effort to eliminate the Write conflict error but it hasn't really
    helped. I've also tried Check11/Refresh then Check7/Refresh but that
    has really helped either, similar unsatisfactory result.

    Each checkbox is bound to its own field in a table.

    Any suggestions how I can fix this problem?

    TIA Eric

  2. #2
    Join Date
    Feb 2004
    Posts
    7
    i too would like to know an answer to this, PLEASE HELP

    Dave.

    Quote Originally Posted by Noops
    I'm currently receiving the error msg. below as I close a report.

    "This record has been changed by another user since you started
    editing it. If you save the record you will overwrite the changes the
    other user made."

    "Copying the changes to the clipboard will let you look at the values
    the other user entered and then paste your changes back in if you
    decide to make changes."

    " SAVE RECORD COPY TO CLIPBOARD DROP CHANGES "


    I have an On Close event procedure for the report as follows:

    Forms!MenuBeth!Check11 = True
    Forms!MenuMain!Check7 = True
    Forms!MenuBeth.Refresh
    Forms!MenuMain.Refresh

    I added the refresh statements as recommended by another in an
    effort to eliminate the Write conflict error but it hasn't really
    helped. I've also tried Check11/Refresh then Check7/Refresh but that
    has really helped either, similar unsatisfactory result.

    Each checkbox is bound to its own field in a table.

    Any suggestions how I can fix this problem?

    TIA Eric

  3. #3
    Join Date
    Feb 2004
    Posts
    7
    Quote Originally Posted by davews
    i too would like to know an answer to this, PLEASE HELP

    Dave.


    heres the error.

    dave
    Attached Thumbnails Attached Thumbnails ole error.JPG  

  4. #4
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Write Conflict

    Not sure if this helps, but I had the same problem some time ago.

    First check that you don't have two forms or reports open at the same time bound tot he same data source. I think the statements:

    Forms!MenuBeth!Check11 = True
    Forms!MenuMain!Check7 = True

    are causing your problem, as (I am guessing) the form is open and you are changing data that is bound to the form.

    Any statment changing that sort of information needs to be somewhere in the form, possibly in code that is fired off by an event on the form (close etc).

    Other than that I would need more information about the way the database is structure, what objects are open etc etc. Sometimes this can be cause by convoluted use of form -> query -> form being opend and looking at the same data.

  5. #5
    Join Date
    Feb 2004
    Posts
    7

    Thumbs up

    Quote Originally Posted by Ryker
    Not sure if this helps, but I had the same problem some time ago.

    First check that you don't have two forms or reports open at the same time bound tot he same data source. I think the statements:

    Forms!MenuBeth!Check11 = True
    Forms!MenuMain!Check7 = True

    are causing your problem, as (I am guessing) the form is open and you are changing data that is bound to the form.

    Any statment changing that sort of information needs to be somewhere in the form, possibly in code that is fired off by an event on the form (close etc).

    Other than that I would need more information about the way the database is structure, what objects are open etc etc. Sometimes this can be cause by convoluted use of form -> query -> form being opend and looking at the same data.
    Hi, thanks for the info, but thats not it [i think].

    I have a bound ole on a form, nothing else open, this ole is locked and there for viewing only, but when viewed and closed access thinks the data has changed but because it is locked you get the above massage.

    i guess i just want this to be read only when locked.

    any ideas?

    cheers
    Dave.

  6. #6
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Bound OLE

    I stopped using bound OLE controls years ago because of the problems they cause. It may have been his individual approach but one of my colleagues managed to lock a number of databases, which I eventually had to rewrite, using bound OLEs. If you have an image in the OLE control I would seriously suggest using an image box. If it's not an image I'm not sure what approach to rake, but I would seriously consider using some other type of control if possible.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •