Error message: "this recordset is not upateable"

  • Thread starter Thread starter Misfer
  • Start date Start date
M

Misfer

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

Thnx
 
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
 
Back
Top