Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Operation must use an updatable query????

Status
Not open for further replies.

marlun

Programmer
Feb 7, 2003
70
SE
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
 
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.
 
If you want to use values from another table in an update statement in Access you could use the following syntax

e.g.

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

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top