buranfolio

Access is able to update linked tables only when they have a primary key. When they don't have one, you'll get the 'This Recordset is not updateable' error. If the underlying SQL Server table has a primary key, Access will usually detect it and use it in the linked table as well. If the table does not have a primary key on the server, or if it's a view and not a table, Access is not able to set a primary key by itself. If you link a view manually per DSN, a window will pop up and ask you to select the columns which Access should consider as the primary key: When you link the table DSN-less (i.e. Per code) and you don't specify a primary key, Access will link the table without primary key.

So I suppose that the table you're talking about is either a view or it has no primary key. When it was originally linked with DSN, someone selected the primary key in the popup window shown above. Free Download The Game Farkle Rules Programs For Mac. When you re-linked it with your DSN-less code, you probably didn't set the primary key, and that's why you're getting the 'This Recordset is not updateable' error now.

Consultant in MS Access/SQL Server/Visual Basic/Corel Paradox Over 15 years' experience. Member, Independent. Both of these tables are defined w/ Primary keys. But when I try to update the table is giving an error in Access form: 'This recordset is not updatable'.=20. Would anyone have an explanation for this? But with 1 form, no matter what field I update, I got this error. This recordset is not updateable I read this article I tried many things. Nothing work There's no relation, I got the navigation control, the form is dynaset, I have a primary key autoincrement, allow edits is. Dealing with Non-Updateable Microsoft Access. There are situations where the query results are not updateable. Error Message: This Recordset is not updateable.

Solution: After linking the table with your DSN-less code,.