Why cant my query update a linked table?

  • Why can't my query update a linked table? I have a query in MS Access that has a linked (ODBC) SQL Server table as it's source. To get the results I need the query uses three separate fields for criteria. The query returns the correct data set, however when any data is changed / updated in the query, a write conflict message occurs. The exact message is: "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." There are no other users, and the SQL tables have been created with at least one primary key.

    If two of the criteria are removed the query then becomes updateable. Is this a limitation (only one criteria field) of a query using a linked SQL Server table?

    Any help would be greatly appreciated.

    Dan the man.

  • can you post the query ? and the ddl of the used object(s) in sqlserver.


    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Are there any triggers on the SQL table? That could be part of the problem.

  • Nope.  Not that good yet.



  • check this out


    * Noel

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

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