Recordset Not Updatable

[abrown]

Any ideas why my query would all of a sudden say "Recordset Not Updatable"?

 

[Norie]

It could a number of reasons. When you say 'all of a sudden' were you able to edit it before?

Have there been any, even minor changes, in the tables/queries that this query is based on?

 

[abrown]

I got it all figured out. My problem didn't have anything to do with the "Recordset Not Updatable". Thanks anyways.

 

[mdmilner]

Even though it's fixed, as a guess, it's related to what happens in Access when you attempt to open an object in design mode when it's already open from VBA.

Next time you think about it, start stepping thru a function and then try to open up the QBE Wizard. Access will give you some nonsense error essentially saying the wizard doesn't exist. Stop/Cancel the code suspended function and you'll be able to open the QBE again.

Mike

 

[Norie]

Mike

Most of the time I've encountered this it has been to do with relationships and joins in queries.

Normally it's my own fault - not setting the join properties correctly or picking the a field from the wrong table.