|Question: Does Microsoft Access require a unique index to update a linked SQL Server table?
Microsoft Access requires a unique index (unique index: An index defined by setting a field's Indexed property to Yes (No Duplicates). A unique index will not allow duplicate entries in the indexed field. Setting a field as the primary key automatically defines the field as unique.) to update, delete, or insert data in a linked SQL table or view. When you link a Microsoft SQL Server updatable view, or an SQL database (SQL database: A database that is based on Structured Query Language (SQL).) table that doesn't have a unique index, Microsoft Access asks you to select one or more fields to generate a unique index. However, Microsoft Access doesn't test to make sure that the fields you selected uniquely identify each record. If there are duplicates in the index Microsoft Access builds, you won't be able to update those records.