We help IT Professionals succeed at work.

This recordset is not updateable issue

Michael Noze
Michael Noze used Ask the Experts™
on
Hi Experts,

I'm having an issue with a recordset.
In my query "qryInspection", I can't seem to check or uncheck the checkboxes.
It says: "This recordset is not updateable."
I didn't set any relationship, so I'm not sure why it's doing this.

Is there a solution to this?

qryInspectionqryInspection2tblEquipementtblAssignation
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
When you have a query which holds any kind of aggregation the query is not updatable
If you want to check the checkboxes....remove the Aggregation (Group By/Expression) and you will see it will work
If you want to check the checkboxes while keeping the query you need to work the base table (tblEquipment) do the checking and then work with the query.
Looking at your query, I notice that neither of your tables have a primary key defined, and there is no join between the two tables.

I would recommend working with your table design, and normalization first, before starting queries.
ste5anSenior Developer

Commented:
Please embed images in your post using the image button. This makes reading of your post simpler as there is no need to switch tabs in the browser. Edit your post.
Distinguished Expert 2017
Commented:
I don't see that you are selecting any columns from the second table.  Joining to this table, especially using a cross join (Cartesian Product) will produce duplicates and that is probably why you need the Group By.  Getting rid of the second table might allow you to get rid of the Group By and that will allow the query to be updateable

Author

Commented:
Thank you Pat, you were spot on, it worked perfectly.
Distinguished Expert 2017

Commented:
You're welcome.  Sometimes it just takes fresh eyes and mine are as "fresh" as it gets :)