Link to home
Start Free TrialLog in
Avatar of dfranciosa
dfranciosa

asked on

MS Access Database - Read Only

Hello Experts,

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.

Avatar of dfranciosa
dfranciosa

ASKER

Note - I just tried to access it again and even though there was no .ldb file present and the .mdb property is not set to Read Only, the database still gave me the Read Only message when I attempted to open it.

I did try 'Compact and Repair', but the error message the database was already in use?  There was no .ldb file when I accessed it.
SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
1. Check the share and make sure that the permissions are set to allow full control for everyone.
2. Check the directory security and make sure that everyone has full privs (read, write, delete).
  See if the problem then goes away.
  My guess is that it is some type of authentication/security issue.
JimD.
Experts, thank you for your quick answers -

Capricorn - Putting the database on my local drive produces no read-only errors.  Therefore, it must be the network.

JDettman - I will follow-up on our folder permissions.  The thing is that I have read/write/delete privileges for this folder.  But for some reason, I cannot access the database.
Also, I am able to open all other files in this folder (i.e. Excel and Word documents).  If the file permission was set to read only, would I not get an error for these as well?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hello Experts,

Thank you for your help.  Unfortunately, we continue to experience the issue and I have forwarded a request on to our IT department.

Much appreciated.
<<Thank you for your help. Unfortunately, we continue to experience the issue and I have forwarded a request on to our IT department.>>
So then I have to ask; why did you accept a comment as an answer?  You could (and should) have requested a deletion of the the question.
JimD.
JimD - The problem was correctly identified as a folder permission issue.  Separate from that is resolving that on our end.  For this reason, the solution was accepted.