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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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)Commented:
can you copy the db and load to your local drive.
open the db and see what happens..
0
carsRSTCommented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
Jim Dettman (Microsoft MVP/ EE MVE)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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.