Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    31

    Unanswered: "The record has been changed by another user"

    I'm getting Microsoft Access's Write Conflict error message box whenever I try and change a record. The database is a front-end to an SQL Server DB and uses linked tables.

    I added a record using the MS Access DB, if I then try to edit that record it works fine. However, I imported a load of data from the old MS Access DB using an INSERT..SELECT statement to transform the data. Although it copied it across, any of those records can no longer be edited.

    What's causing this? I found a KB article that suggested updating a field to it's original contents that would fix a timestamping issue and allow further records to be edited. However, this didn't work.

    Anyone have any suggestions please?

    Regards,
    Paul

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    You have a problem of lock edit, the record added are lock in the old Ms Access DB, i don´t now why but are locked.
    Saludos
    Norberto

  3. #3
    Join Date
    Mar 2002
    Posts
    31
    In the end I decided I'd try and figure out how Access performs its locking + determines whether records have changed. I then decided I'd try and monitor timestamp values as they went between client and server to see if there was some kind of weird changing.

    What I didn't realise was SQL Server/Access don't automatically use timestamp values, instead Access by default checks each field to see if its changed. By adding a timestamp field it works, just in case anyone else stumbles across this problem in future.

Posting Permissions

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