Update query problem

S

senor_baub

I am trying to use an Update query to replace the values in a table with the
result of a select query but I keep getting the message 'Operation must use
an updateable query'.

Are Update queries not allowed to use data from Select queries?
 
D

Duane Hookom

Access is quite picky about what is allowed in any updateable query. You must
join on a primary key field of the query/table providing the update to value.

If you shared you SQL and table structures, someone might help you re-write
your query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass-Through query used to update an access table 2
Dynaset, inconsistent updates 20
Crosstab query as data source for update query 7
Must use an Updateable Query - Issue 0
update query 2
Access update query 2
Subquery nested in Update query 1
SQL Query UPDATE & SELECT COUNT does not work 1

Top