Write Conflict with MS Access Front end

Discussion in 'Databases' started by PattiN, Jan 13, 2015.

  1. Hi,

    I am fairly fluent in MS Access and VBA, but new to SQL Server. We have a MS Access front end connecting to SQL Server on Winhost. I am trying to add a few fields to two tables, using MS SQL Server 2014. I was able to make the connection to the DB on Winhost, add the fields to the two tables, and update the View in SQL Server. (Access is linking to the View, not to the table.) In the front end, I re-linked the tables. The problem now is that for only one of the newly updated tables, I get a Write Conflict error when I try to make any changes to a record. If I use an older front end file, I get no Write Conflicts. As soon as I re-link the tables, I get a Write Conflict on only one of the tables. I tried linking directly to the table, rather than to the View, but still get a Write Conflict.

    If anybody could help me out, I would greatly appreciate it! Thanks!
     
  2. ComputerMan and Elshadriel like this.
  3. Thanks for posting the link.

    Dealing with anything Microsoft often means dealing with the obscure, unfortunately. But I'm glad you stuck with it. Your determination will help someone else in the future.
     

Share This Page