Update Query Problem not Updateable Query

[Rick]

in my database I have a table that is linked by ODBC from
a SQL database, when I run an update query it gives me
an error that the query must be run from an updateable
query, but if I import the linked table it works fine.
Any suggestions on why the linked table would not allow
the other table to be updated?

 

[Rick Brandt]

in my database I have a table that is linked by ODBC from
a SQL database, when I run an update query it gives me
an error that the query must be run from an updateable
query, but if I import the linked table it works fine.
Any suggestions on why the linked table would not allow
the other table to be updated?

Is the link updateable? When you link to an ODBC table that has a Primary
Key defined then Access will use that key and the link will be updateable.
If the source table does not have a PK then Access will prompt you when
creating the link to indicate which column(s) Access should use to build a
local unique index and again the link will be updateable. If the source
table does not have a PK and you do _not_ tell Access which columns to
build a unique index on then the link will be read only.

Also, if you tell Access which columns to use for a unique index and then
later refresh the link, that information will be lost and the link will
become read only.