"This Recordset is not updateable."

[gregski]

Good morning,

First of all, let me tell you that I am a complete nooB when it comes to Access, as far as any programming goes. I took over the duties of maintaining a personnel database of a group I belong to. I have been humming along for the past 3 years with instructions given to me by my predecessor for running queries, printing reports and such, but all the formulas were in place when I started. Now, all of a sudden, when I run a query that I have run hundreds of times before, I getting the "not updateable" message when I try to alter a field. As far as I know, I haven't made any changes to the query or any other formula. In searching for solutions, I see plenty of people with the same problem, but the solutions go WAY over my head. Can anybody steer me in the right direction? Maybe Access for Dummies? Thank you in advance.

Edit: Forgot to add that I am using Access 2013

 

[CJ_London]

you can try the book or try some of the lessons on line

http://www.dummies.com/how-to/computers-software/ms-office/Access/Access-2013.html

 

[gregski]

There is actually a book? I said that tongue-in-cheek. I was actually hoping that someone could put me in a more focused direction. Thanks for the link though.

 

[namliam]

a non-updateable recordset is the result of
1) A locked database, you cannot change anything
2) A locked query, only the one query is locked
a) the query is a "Crosstab", which is never updatable... this would likely change the query and is unlikely....
b) the query is a result of a "Group by" query, this is the result of clicking the sigma sign in the ribon... doesnt need to change the result of the query but does lock it
c) the is a join with 2 tables and the join fields are not proper primary keys
d) the query is a union query, which isnt updatable, but assuming limited knowledge... this is unlikely

b would seem the most likely, with c as a quick second option.

 

[gregski]

a non-updateable recordset is the result of
b) the query is a result of a "Group by" query, this is the result of clicking the sigma sign in the ribon... doesnt need to change the result of the query but does lock it

b would seem the most likely

B it is! Thank you so much. I knew it had to just be something I inadvertently clicked on. Now....back to "Access for Dummies"!