-
Updateable Query
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
-
please supply type of database and the sql you are running
-
Update Query
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
-
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.
-
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*"));
Last edited by Rawhide; 12-17-2004 at 06:06 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|