Post reply

Write Conflict

  • October 28, 2003 at 9:26 am

    #160837

    Wee have a Access application that uses SQL for the database part, the problem here is that the application was not develop as a access project but as a access database with link tables via odbc, now the problem that I'm having is that when wee try to make a change in a record a get a "WRITE CONFLICT. This record has been changed by another user since you started editing...." and this is happening even when there's only one user running the application.

    Please advice

  • October 28, 2003 at 10:27 am

    #479920

    See MS Knowledge base article 280730:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;280730

    I opted for the 'add timestamp column to table' fix. No more WRITE conflict errors after that.

    Good Luck!

    bb

  • October 28, 2003 at 10:29 am

    #479921

    It happened to me when I have bit field type in the table.

    My scenario: I imported data into the table but nothing is specified for the bit field. i.e. the bit field is null. After that the write conflict error started to appear.

    My Solution: I set a default value of 0 for the bit field.

    Hope it helps!

  • October 28, 2003 at 10:32 am

    #479922

    oops! billyburns posted the same solution while I was in the middle of typing. Sorry for the duplicate posting!

  • October 28, 2003 at 10:34 am

    #479925

    IT WORK!!!!!

    THANKS A LOT

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply