Update query problem

  • Thread starter Thread starter senor_baub
  • Start date Start date
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?
 
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

Update primary key field with multiple "where" clauses 0
Must use an Updateable Query - Issue 0
Access update query 2
Error: Operation must use an updatable query 2
update query on a JOIN Table with a query Not Work 1
Crosstab query as data source for update query 7
query is not updatable;; urgent 1
Append Problem 4

Back
Top