“Operation must use an updateable query” error in MS Access

Question

This question has been asked many times, my case seems to be the simplest, still I did not find the answer to my question...

The environment is Windows, Access 2013. Table tbl_rap is linked, resides on MS SQL Server 2007

Table tbl_rap is constructed as follows:

id - int (Identity)
field_1 nchar(10)
field_2 nchar(1)

The following code works

sql_cmd = "INSERT INTO tbl_rap (field_1,field_2) VALUES ('010308HB3','R')"
DoCmd.RunSQL sql_cmd

But this code

sql_cmd = "UPDATE tbl_rap SET field_2 = 'X' WHERE field_1 = '010308HB3'"
DoCmd.RunSQL sql_cmd

fails with run-time error 3037 "Operation must use an updateable query"

Any help would be appreciated.

This is very much like [this previous question](https://stackoverflow.com/questions/19789709/operation-must-use-an-updateable-query-error-in-ms-access), but only one of the answers looks appropriate to me. Try `UPDATE DISTINCTROW` instead of just `UPDATE`. — Laughing Vergil, Jul 17 '19 at 16:28

score 0 · Answer 1 · answered Jul 17 '19 at 20:27

0

As you use nchar(10), you must pass a string of 10 characters, say:

sql_cmd = "UPDATE tbl_rap SET field_2 = 'X' WHERE field_1 = '010308HB3 '"

answered Jul 17 '19 at 20:27

Gustav

I changed the code as recommended, unfortunately the problem persists... – RAP Jul 18 '19 at 14:10
It was just an example. Clearly, the search text doesn't match the actual field text, so double-check the field content. – Gustav Jul 18 '19 at 14:36
If the UPDATE could not find a matching record in the table, it would fail differently. – RAP Jul 18 '19 at 15:11
Then you probably miss a _timestamp_ field in the table and to relink the table after having added this. – Gustav Jul 18 '19 at 17:53
How did you arrive at the notion that a timestamp field is needed? – RAP Jul 19 '19 at 13:02
Because that is often the reason for a table being non updatable. – Gustav Jul 19 '19 at 15:02

1 Answers1