Access query - "This recordset is not updateable"
I have a simple Access query that takes all the fields from one table, and also uses another table with a corresponding field to set a criteria.
The query is the recordsource of a form, and in the form if I try to edit anything I get a message - "This recordset is not updateable".
How can I fix this?
In case it helps, here is my query:
SELECT CartonDimensionsT.*, NewProdT.division
FROM NewProdT RIGHT JOIN CartonDimensionsT ON NewProdT.NewProductBatchID = CartonDimensionsT.BatchID
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.