Error message: "this recordset is not upateable"

M

Misfer

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

Thnx
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Performance in 2007 1
Join Key not in recordset 2
getting a value in a table based on combo box selection in form 3
Requery Problem in Access 2007 1
unbound forms 3
How to Set Value on form using macro 2
Using Combo Box in a Form 2
Non updateable recordset 2

Top