Article ID: 304179 - View products that this article applies to.
This article was previously published under Q304179
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
In Datasheet view of a table, in Datasheet view of a query, or in a form, when you try to update or add records, the status bar displays the following message,
This Recordset is not Updateable.
The table that you are updating is a linked table that does not have a primary key or a unique index. Or, the query or the form is based on a linked table that does not have a primary key or a unique index.
To add the primary key or a unique index, use either of the following methods.
Using SQL Server Enterprise Manager
Using Microsoft Access
For additional information about how the UniqueTable property affects data access pages, click the article number below to view the article in the Microsoft Knowledge Base:
263650For more information about the UniqueTable property, click Microsoft Access Help on the Help menu, type uniquetable property in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
(http://support.microsoft.com/kb/263650/EN-US/ )ACC2000: How to Use the UniqueTable Property of a Data Access Page
For more information about when data is or is not updateable, click Microsoft Access Help on the Help menu, type when can I update data from a query in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.