Microsoft KB Archive/304179

= Status bar displays an &quot;Recordset is not updateable&quot; message when you try to update a linked table in Access 2000 =

Article ID: 304179

Article Last Modified on 8/12/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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).



SYMPTOMS
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.



CAUSE
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.



RESOLUTION
To add the primary key or a unique index, use either of the following methods.

Using SQL Server Enterprise Manager
 Click Start, click Programs, click Microsoft SQL Server, and then click Enterprise Manager. Locate the linked table in Access. Right-click the table, and then click Design Table. To set a primary key, skip to step 10. To set a unique index, continue with the next step. Right-click the field that you want to set as a unique index, and then click Indexes\Keys. In the Properties dialog box, make sure that the Indexes\Keys tab is selected. Click New.</li> Click to select the Create UNIQUE check box.</li> Click Index.</li> Click Close to close the Properties dialog box. Skip to step 11.</li> Right-click the field that you want to set as a primary, and then click Set Primary Key.</li> Close the table. When you are prompted to save the changes, click Yes.</li> Start Microsoft Access.</li> Open the database that contains the linked table.</li> On the Tools menu, point to Database Utilities, and then click Linked Table Manager.</li> Click to select the check box for the table that you updated. Click OK.</li> Click OK to the message:

All selected linked tables were successfully refreshed.

</li></ol>

You can now update and add new records to the table.

Using Microsoft Access

 * 1) Start Microsoft Access.
 * 2) Open the database.
 * 3) Select the table that you cannot update.
 * 4) On the Edit menu, click Delete.
 * 5) On the File menu, point to Get External Data, and then click Link Tables.
 * 6) In the Link dialog box, under Files of type, click ODBC Databases.
 * 7) In the Select Data Source dialog box, select the correct data source, and then click OK.
 * 8) In the Link Tables dialog box, select the table that you deleted in step 4, and then click OK.
 * 9) In the Select Unique Record Identifier dialog box, select a field as the unique index, and then click OK.

You can now update and add new records to the table.

<div class="references_section">