Article ID: 278696 - View products that this article applies to.
This article was previously published under Q278696
Advanced: Requires expert coding, interoperability, and multiuser skills.
For a Microsoft Access 2000 version of this article, see 280730
You receive the following write conflict error when you try to update records in a linked SQL Server table:
You are then given the following options: Save Record, Copy to Clipboard, or Drop Changes.
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.
Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.
To resolve this problem, do one of the following:
Steps to Reproduce BehaviorThe following steps assume that you have an understanding of how to create tables in SQL Server, and that you are familiar with certain SQL Server tools such as Enterprise Manager.
Also assumed is that you are aware of how to create File, User, and System Data Source Names (DSN), and how to use a DSN to link a table to a Microsoft Access 97 database.
Article ID: 278696 - Last Review: January 29, 2007 - Revision: 3.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.