Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dealing with "Operation Must Be An Updateable Query" error.

Other

Dealing with "Operation Must Be An Updateable Query" error.

by  SQLBI  Posted    (Edited  )
Hi,

I have recently had problems using a Sub Query within an UPDATE Query. Each time i ran my code, Access prompted with "Operation Must Be An Updateable Query."

Looking at various TT posts, this is not an uncommon problem.

My original SQL was;

Code: 
UPDATE tblAgreement AS A SET A.DateReceived = (SELECT AI.DateReceived FROM tblAgreementImport AS AI WHERE A.UniqueID = AI.UniqueID);

But each time i ran it, the error would pop up.

This problem was solved using the following SQL;

Code: 
UPDATE tblAgreement AS A INNER JOIN tblAgreementImport AS AI ON A.UniqueID = AI.UniqueID SET A.DateReceived = AI.DateReceived;

This worked 100%.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top