I've got kind of a weird problem, and I haven't been able to find an answer. I'm accessing a sharepoint list through Access, and I'd like to change a "status" field from "pending" to "complete". When I try to make that change, I get a popup that says "Cannot Update. Database or object is read-only." I've given myself contribute rights to the sharepoint list in question, and though I can add to the list, I cannot modify what already exists. No formulae are being applied to the field I'm trying to edit, either. Does anybody have recommendations on how to diagnose and root out this problem?
Follow-up answer: The trouble is that I was trying to unit-test my updates within the Datasheet view of my employee table. When I implemented a change directly through a query, I had no troubles. Thanks to JayHell for providing the context that allowed me to deduce this.