Operation must use an updatable query????

[marlun]

Hello!
I've an update query that gives me following error message Operation must use an updatable query. (Error 3073)

Is it because I have an updatequery that depends on several select queries that collects the values i want. ?????

please help

 

[tracy1234]

I've gotten around this by storing the values resulting from the multiple selects in a temporary table. Then use the temp table to get the update data.

 

[swampBoogie]

If you want to use values from another table in an update statement in Access you could use the following syntax

e.g.

update t1 inner join t2 on t1.pk = t2.pk
set t1.npk = t2.npk
where t1.pk = 4711

 

[marlun]

Hi again. I have a question to tracy1234. I wonder how you get the value from the select queries into the temp-table.
I using an update-query to insert the value into the temp-table. But I get "Must use updatable query!"

I don't know what to do?????

thanks

/marlun