Random "Database has been opened read only" problem

[George-Bowyer]

I have searched and read half a dozen "read only" threads. None of them get a definitive solution.

Every now and then, for no discernible reason, my database has a message that says "This database has been opened as read only. You can only change data in linked tables. To make design changes, save a copy of the database" and has a [Save As...] button.

Quite often when I try to make a copy of the db with a slightly changed name, it won't let me, telling me that the database is in use.

This is my own db frontend on my own laptop. There are no other users on this laptop and the laptop is not connected to a server.

The db is located in My Documents/databases

(The back end is in sharepoint tables via office365). There are some other people with copies of the front end on their machines, but they hardly ever connect.

The only "pattern" that I have seen in this is that it quite often (but not exclusively) occurs just after I have copied a backup copy into my copies folder.

Can anyone suggest why this might be happening and how to stop it.

I am running windows 10 and access 2016

 

[The_Doc_Man]

While it is not by any means a definitive answer, this kind of behavior could occur if the lock file was not releasing very quickly. If you cannot access the lock file, Access will only allow read-only access.

Can you see the .LDB file (or whatever it is that Sharepoint uses)?