Update query problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

senor_baub - 21 Apr 2008 21:31 GMT

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?

Reply to this Message

Duane Hookom - 21 Apr 2008 21:59 GMT

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.

Signature

Duane Hookom
Microsoft Access MVP

> 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?

Reply to this Message