This Recordset is not updateable!

[mfearer94]

So I keep on getting the error "This Recordset is not updateable" when I try to change a value of a record in the form or query.

What I have right now in my database is 1 main table that has 1 subdatasheet and that has a subdatasheet.


These are all linked by a query which is then used by a form.
I read somewhere that you can't edit information that is linked between 2 or more tables.

Can you think of anything else I can do to solve this problem?

Thank you so much for your time! Any help is appreciated.

[TG_W]

The problem is the querying of multiple tables. If there is data underneath data underneath data, you might consider a separate form for each, and you can drill down further and further as needed by double-clicking on the field you want to update or add a button to open the source table in a form to update it.

Without seeing your database and how all of your information is tied together, that would be my guess at resolving your issue.

[John_G]

Sometimes queries joining two or more tables can be made updatable by putting indexes on the fields used to join the tables. I have used that technique with some success.

[RuralGuy]

Maybe you will find something on this link helpful: http://allenbrowne.com/ser-61.html