Error: Recordset is not updateable

Answer

Environment:
Microsoft Access 2007
NPS 4.6.5
ODBC Driver 4.6.5

If you link your Microsoft Access database to your Netezza database and you do not specify a column in the Select Unique Record Identifier dialog box, then your table will not be modifiable and will result in an error. You may have thought that this step is optional because when you link Access to SQL Server, it automatically chooses these fields for you. However, when you link Access to the Netezza database, you must specify the unique record identifier using the following dialog box:



If you do not specify the unique record identifier, when you try to update the table, you will get an error, This Recordset is not Updateable. This error message appears in the lower left status bar as seen below:



You will need to re-link the table to your database and choose the unique record identifier. By doing so, you will be able to update the NPS database through Access.

In older versions such as Access 2002 and Access 2003, you may receive a similar error: Operation must use an updateable query. This is the same condition and it means that you need to re-link and specify the unique record identifier.