Updateable Query

[NewtoSQL]

I'm trying to run an update query and I get the error message "operation must use an updateable query".

Any idea what could be causing this problem?

Thanks

[jkoopmann]

please supply type of database and the sql you are running

[NewtoSQL]

Here is the SQL

UPDATE WINTER2004SN INNER JOIN Members ON WINTER2004SN.Member_num_text = Members.Member_num_text SET Members.Cga_id = [Winter2004SN].[CgaNum]
WHERE (((Members.Cga_id) Is Null Or (Members.Cga_id) Like "2*"));

I'm using MS Access XP Professional

[jkoopmann]

i am not an MS access expert but typically you can not update a table that is involved in a join condition.

you will need to move the join condition into the where clause.

[Rawhide]

I think he means to move it to the From clause:

UPDATE Members
SET Members.Cga_id = Winter2004SN.CgaNum
From WINTER2004SN
INNER JOIN Members ON WINTER2004SN.Member_num_text = Members.Member_num_text
WHERE (((Members.Cga_id) Is Null
Or (Members.Cga_id) Like "2*"));