We have a MS Access database that is located on our network. Lately, we have been getting "This database is read-only" and then when the user opens it and clicks on a button to open a form, they get a macro error.
I have checked the properties of the database and it is not read-only. Also, this does not happen every time the users try to access it. It can happen on Monday, but be fine Tuesday and Wednesday, and then we get the message again on Thursday. I have found this error usually happens between 8 p.m. and 8 a.m. No changes are made to the database between these hours, so I am wondering if a network outage or upgrade can potentially cause this issue.
What I have also noticed is that when this error happens, even though no users are in the database, the .ldb file remains open. Is this a clue?
Thanks in advance.