Error: "Operation must use an updateable query" in update-query

  • Thread starter Thread starter Daniel Schaedler
  • Start date Start date
D

Daniel Schaedler

Hi

I get the following error and don't know why:
"Operation must use an updateable query"


following query:

UPDATE MasterTable INNER JOIN findProducts
ON findProducts.MaterialNr=MasterTable.MaterialNr
SET MasterTable.BR = findProducts.FirstOfBR;

MasterTable is a table, findProducts a query

I guess the problem is the query (??)

daniel
 
Lynn said:
Yes, it matters. Any aggregate function in a query will render it not
updatable.
Click to expand...

thanks for the answer.
But I don't want to update the query! I only want to update the table.
Is there a possibility the update the table and get the data from the query
in any other way?

daniel
 
But I don't want to update the query!
Click to expand...

A Query has no independent existance. If you want to update the Table,
you must either open the table directly, or open an updateable Query
based on the table.
I only want to update the table.
Is there a possibility the update the table and get the data from the query
in any other way?
Click to expand...

You could have a Form with a Subform, or two side by side Forms, or
you could use DSum() or DCount() to get your totals.
 
Back
Top