Access 2010 front end to SQL Server 2012 Operation must use an updateable query

[SandyShin]

The Access database shows linked table to SQL Server (tblWork) and maintains local copies (tblWork_Local)
Before I upgraded to this configuration from a simple Access database, this update query worked
UPDATE tblWork
INNER JOIN tblWrkWkAllDates
ON tblWork.BDT = tblWrkWkAllDates.WDate
SET tblWork.WrkWkID = [tblWrkWkAllDates].[WkID];
Now I get the error
Operation must use an updateable query
when I try to run it on either the local or linked tables.
Why is a query using two tables and updating only one table unupdateable?
Help, this is really making me nuts:banghead:

 

[Pat Hartman]

Did you change the keys of either table? For ODBC linked tables, the table MUST have a primary key or unique index or Access will not be able to update it and if either table is not updateable, the query will not be updateable.

 

[SandyShin]

The tables supplying the correct value did not have a primary key. When I identified one, the query works. Who would thunk it.
Thank you.

Do you know of any source for information on using Access as a front end, or for upgrading ACCESS to SQL Server?

 

[syswizard]

Lots of good material here:
http://www.techrepublic.com/search?q=access+SQL+Server&e=1

 

[SandyShin]

Really useful information, thank you very much