Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Ms Access cannot edit the data in a query with two table source

Copper Contributor

Hi, 

 

Can anybody help me what to do on my Access form. My form data source is a query with two tables. Initially, I can edit my data in a form with 1 table source but when I added another table with 1 to 1 relationship, it did not allow me to edit. I've already set the  RecordsetType property of the form into Dynaset(Inconsistent Updates) but still it doesn't work. Hope can anyone help me to resolve it. Thank you in advance.

3 Replies
1=1 relationship?
you can just combine it into 1 table if that is the case.
also try to make the other Pk an FK.
Hi arnel_gp,

To simplify, I just combine the 2 tables into 1.
Thank you!:smiling_face_with_smiling_eyes:
There are circumstances where results of a query cannot be edited, typically because Access doesn't know which row is being edited. This may be informative - but when it says "three or more tables" that is misleading because it is possible to design a query on one table that cannot be edited: https://support.microsoft.com/en-us/office/edit-data-in-a-query-6ca3edfc-6d66-4d90-8219-c2b258d5bed7