I have rather simple Access 2010 database. I needed to add a new field to one of the tables. While in Datasheet View, I Clicked the "Click to Add" column header and defined a new field.
I went to one field, in the existing records, and then I typed in a value into the text field. After entering my first data change, I used the arrow keys to move to my next field that I need to enter. Nothing happened as I started to key in information. I moved to another field with data and I tried to modify it. Nothing happened. I closed and re-opened Access. I still can't modify any data on this table.
To be fair, I could have hit a mistaken hotkey. However, I can't find any documentation claiming that tables can be changed to a Read Only state. This seems to have just happened. I really need to update this information and I'd prefer to not have to create a new table since this is a table used in many queries and this is a DB I inherited. I've always found it to be a bit of a nightmare when managing other peoples access files.
FYI, this is not a linked table. It does appear in queries and on forms, and it does have reference fields. However, this table was modifiable and then, all of a sudden, it wasn't. What could I have done to cause this?