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!
Found it! http://answers.microsoft.com/en-us/...ct-error/8052e224-8dcc-48dd-acf3-7a93c346f970 What a freaking obscure waste of several days! lol ;-)
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.