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.

dfranciosaAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
<<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?>>
  One would think, but it's not clear what is at work here.  Generally though, problems like these almost always involve permissions in some way, shape, or form.
  As I said, I would grant full permissions to everyone (the group) and see if the problem goes away.
 If that works, then it's either permissions or an authentication issue.
JimD.
0
 
dfranciosaAuthor Commented:
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.
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
can you copy the db and load to your local drive.
open the db and see what happens..
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
carsRSTConnect With a Mentor Commented:
I would check the folder permissions at the time read only happens.   that's the only other thing I can think of that would make it read only.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
 
dfranciosaAuthor Commented:
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.
0
 
dfranciosaAuthor Commented:
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?
0
 
dfranciosaAuthor Commented:
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.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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.
0
 
dfranciosaAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.