I'm trying to run a very simple update query, like so:
UPDATE tblSkuActueel
INNER JOIN qrySkuTotaal ON tblSkuActueel.sku = qrySkuTotaal.sku
SET tblSkuActueel.stock = [qryskutotaal].[stockaantal];
As you can see, it has to update the table. It should not have any problems doing so.
Yet, I get the error message that I'm trying to edit an uneditable query.
BOTH the tabel and the query are editable, and even then, it only needs to update the data in the table with the data from the query. How can I fix this?