New to update queries...Operation must use....

[kalebson]

Hi,

I have read many of the threads relating to this error, and have tried some of the things in those threads with no sucess. Here is the situation:

I have a table called ForecastedSvcLvl1
I have a query called FCST_SL_QUERY_2

I am trying to update 2 fields in the table for various days using the query. The SQL is as follows:

UPDATE ForecastedSvcLvl1 INNER JOIN FCST_SL_QUERY_2 ON (ForecastedSvcLvl1.ForecastDate = FCST_SL_QUERY_2.FORECASTDATE) AND (ForecastedSvcLvl1.Group = FCST_SL_QUERY_2.CTNAME) SET ForecastedSvcLvl1.FcstSvcLvl = [FCST_SL_QUERY_2].[FCST_SL], ForecastedSvcLvl1.LastModified = [FCST_SL_QUERY_2].[Last_Modified];

I am getting the "Operation must use an updateable query" error. Any help would be greatly appreciated. Thanks.

 

[PNGBill]

One way to "cheat" on this if you are sure your query has returned the correct value is to turn the query into a Make Table query and give the New Table a _tempTableName.

Then run an update query to update from the new temp table.

You may need to put the activity into a Macro or have the tasks follow each other in your VBA code.

As the task is repeated, the temp table is just over written.

You will need to include tasks to turn off warnings and you can even have a final delete query to clear the records from the temp table if you wish and of course, turn warnings back on.

 

[kalebson]

Thanks I will give that a try.