Operation must use an updateable query

  • Thread starter Thread starter Dominic Gualtieri
  • Start date Start date
D

Dominic Gualtieri

If anyone can help me with this it would be greatly appreciated. I am
using MS Access 2000. Here is the query thats generating the
"Operation must use an updateable query" error:

UPDATE ABBREV SET ABBREV.Sugar = (SELECT Sugar FROM Temp WHERE
ABBREV.NDB_No=Temp.NDB_No)

NDB_No is defined as the Primary Key for both tables...

Thanks in advance for your replies...

Dominic
 
If NDB_No is numeric:
UPDATE ABBREV SET ABBREV.Sugar = DLookUp("Sugar", "Temp", "NDB_No=" &
[NDB_No])
If NDB_No is text:
UPDATE ABBREV SET ABBREV.Sugar = DLookUp("Sugar", "Temp", "NDB_No=""" &
[NDB_No] & """")

Duane Hookom
MS Access MVP
 
Duane Hookom said:
If NDB_No is numeric:
UPDATE ABBREV SET ABBREV.Sugar = DLookUp("Sugar", "Temp", "NDB_No=" &
[NDB_No])
If NDB_No is text:
UPDATE ABBREV SET ABBREV.Sugar = DLookUp("Sugar", "Temp", "NDB_No=""" &
[NDB_No] & """")

Duane Hookom
MS Access MVP
Click to expand...

Thanks Duane for your reply. I actually fixed the problem shortly after
I posted the question. I changed the statement so that the SET was after the
join instead of before it. Here it is
UPDATE ABBREV INNER JOIN Temp ON ABBREV.NDB_No = Temp.NDB_No
Set ABBREV.Sugar = Temp.Sugar

Thanks;
Dominic
 
Back
Top