title: "operation must use an updateable query" for UPDATE query on SQL linked table in Access
body: <p>In my Access database I have one temp table - msCurrentAnnualUpload and one linked to SQL server table - msCurrent.</p>
  
  <p>After I try to run Update query I get an error ("operation must use an updateable query").</p>
  
  <p>Text of query is the following:</p>
  
  <pre><code>UPDATE msCurrent 
  
  INNER JOIN msCurrentAnnualUpload ON (msCurrent.ProductID = msCurrentAnnualUpload.ProductID) AND (msCurrent.CountryCodeID = msCurrentAnnualUpload.CountryCodeID) 
  
  SET 
  msCurrent.Y1977 = msCurrentAnnualUpload.Y1977, 
  msCurrent.Y1978 = msCurrentAnnualUpload.Y1978, 
  msCurrent.Y1979 = msCurrentAnnualUpload.Y1979, 
  msCurrent.Y1980 = msCurrentAnnualUpload.Y1980
  </code></pre>
  
  <p>can you help me to find an issue??</p>