How can I fix this "Cannot update. Database or object is read-only" error?

Question

I have a database with a link to a sharepoint list. When I tried to append to this list using a query, the following error seen below is displayed on my screen. Typically when I try to append there will be a couple thousand records and it will append some records but not all at once. How can I fix this error?

Answer 1

There are a few possible reasons for an accdb to become read-only.

1. You actually opened it in read-only mode.
   1. Close and reopen it making sure it's not in read-only mode.
2. The accdb is stored in a location on a network to which you do not read/write/delete permissions and someone else has it open exclusively.
   1. Make sure you only open an accdb FE when it is on your own computer, not from a network location.
3. The accdb was recently downloaded from an internet site and has had the MOWB added to it. Or, and this is more likely, it is marked as Read-Only because it was downloaded from somewhere.
   1. Check for those and resolve if appropriate.
4. There is a problem with the link to the SharePoint Site and lists on it.
   1. Perhaps Access can't identify the Primary Key on the table (list) you are trying to update. Relink the SharePoint lists.

Trouble-shooting requires eliminating possible sources of a problem, one at a time.

There may be other problems beyond those, but eliminate them first. If that doesn't resolve the problem,

Answer 2

Thanks for replying.

1. The file is not in read-only mode.

2. The FE file is on my desktop so I dont open the FE file stored on a network.
3. I didnt download this accdb file from an internet site so I dont believe this would be an issue unless I am misunderstanding this potential issue.
4. I relinked the sharepoint list but I still get the same error.

Answer 3

Did your permissions for the SharePoint site change?

Answer 4

I just checked and I have full control to the Sharepoint Site.