Error message: "this recordset is not upateable"

[Misfer]

Hello
I got this message when trying to update a form based on a query (Access
2007).any clue?

Thnx

 

[Burnsie]

Go to your form properties (Data Tab) and find the property "Recordset Type".
It probably list the type as Dynaset. If you change it to Dynaset
(Inconsistent Updates) this should work.

However, you need to understand what happens when you change to Dynaset
(Inconsistent Updates). You can set yourself up for problems with orphaned
records in the many side of a relationship by setting this property this way.

Check out this link:
http://msdn.microsoft.com/en-us/library/aa207088(office.10).aspx

hth

Burnsie