Hi UtterAccess form, I've had good luck with my questions on this form before so I though you might be able to help me with this problem

I'm trying run a update query but get a message "Operation must use an updateable query"

Instead of having to create another table with all the information I need for the criteria is there a way I can make some sort of temporary table within my query or any other advice would be helpful

Thanks for all your time and help

Corey

Well I am not sure what you would be needing a temp table for in relation to the error. The error you got seems to imply that your query does not permit changes to data. Perhaps if you post the SQL of your query it might help figure out what's wrong.

Mike

Thanks Mike

The table dbo_VC_AdminServices is off of our server

I'm just using that to make the criteria and the test table is the one I'm updating to

[sql]UPDATE dbo_VC_AdminServices INNER JOIN test ON dbo_VC_AdminServices.app_num = test.app_num SET test.act_fund = Yes;[\sql]

Hmmm not sure... what about the order in which the tables appear in the query?



Mike

Or, perhaps, move the SET argument where SQL expects to find it:

UPDATE test SET test.act_fund = Yes INNER JOIN dbo_VC_AdminServices ON test.app_num = dbo_VC_AdminServices.app_num

Do both tables have a primary key? If not, that will often make un update query fail with that error.