This Recordset is not updateable

[jfield817]

"This Recordset is not updateable" is the error
msg at the lower left hand corner of a Form
when I try to modify a field of an Access 2000
application

Any ideas ?

Thanks
John

 

[montrose]

If your form is based on a query, check out MS Access Help for when you can update a query. Depends on number of tables in query, etc. HTH Learn what you can and share what you know.

 

[jfield817]

It's a standard Select query and an order clause .......
This apparently had worked under Access 97 ...
I haven't found anything in help thus far
with that error message ...

Still Looking ...

John

 

[montrose]

OK, type in Help, "When can I update data from a query?" and it will detail when you can/cannot. This usually happens if you have more than three tbls in your qry, or you're have one to many relationships. Can be done if you have the form's RecordsetType property set to 'Dynaset(InconsistentUpdates). That Help topic explains all the differences. Post back if you still need help to figure it out. Learn what you can and share what you know.

 

[jfield817]

It's a one-table query ..however the Recordset property
had been set to Snapshot ....(which are R/O by definition)
so I changed it to Dynaset .....which are updateable...
but now when the form comes
up its in the Add mode ...showing me a Form with blank
fields ......

John

 

[montrose]

Also look at it if you've got the form's DataEntry property set to 'Yes'. That will ONLY allow the form to come up for data entry. Also check your AllowAdditions, AllowDeletions, and AllowEdits properties. If they are set to NO, they basically make your form read-only, can add, edit, etc. Learn what you can and share what you know.

 

[jfield817]

All the above mentioned properties are set to Yes ...
I don't understand why when I switched from Snapshot to Dynaset ...I was put in Add Mode and there were 0
records ...

Thanks
John

 

[montrose]

Gotta go out for a while, but check each control on your form and make sure that you have not Locked any of the controls. The only other thing I can think of at the moment is to just design your form using the table itself as the recordsource. There's no other reason I can think of as to why you should NOT be able to enter data into a form if it's based on only one tbl unless you've got something unusual in the qry itself. Post the qry if necesssary, somebody's gotta be able to figure this out! Learn what you can and share what you know.

 

[jfield817]

It works in the DataSheet view ...ie.
the DataSheet is Updateable.....

John

 

[montrose]

John, Back here now-When you say "DataSheet view ", are you referring to the 'Form' DataSheet view? If it works like that, it should work also work in the Form 'Form' view. This drive's me crazy-we both know it's gotta be something simple!

OK, if you're referring to the tbl 'Datasheet' view, then we may just need to back up a little. Did you design your form from a blank form in Design View or did you use the Wizard? If you're talking about just getting data from that one tbl, then the Wizard does a decent job of getting it all together for you initially. Pick out the tbl you want to use, tell it what appearnce you want, etc. You can just take what the Wizard designed and then go into it in design view and polish it up or re-align your controls as needed. Let me know so we can figure this out...... Montrose

Learn what you can and share what you know.

 

[jfield817]

I made sure DataEntry was set to NO and
the Recordset Type set to Dynaset and the data
was retrieved and it was Updateable .....

The kicker was setting the DataEntry property to NO...
which did the trick (a Microsoft semantic ambiguity)

Thanks for ur help
John

 

[montrose]

John, Glad you got it working! When I didn't hear back, I thought-......didn't work-what now?. Hate how it's usually something so simple but you gotta go through 90 hoops to figure it out. Thanks for letting me know. Montrose Learn what you can and share what you know.