database opened as read only

Fordraiders
Fordraiders used Ask the Experts™
on
Access 2010.

I have a problem that just creeped up.
Everytime I open a database  the database opens as ready only.

I have tried the suggestion from "stackflow" open the database as "read-only" close it and reopen while not closing access.
But does not help.
I checked my admin log in ...I'm logged in as admin ?

Thanks
fordraiders
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
Commented:
Check your DOS permissions.  Access creates a lock file when it first opens.  Therefore, if you do not have create permissions on the folder holding the database, Access cannot create the lock file and will open it read only.  Same for update permissions.  Even if someone has already opened the BE and the lock file exists, if you don't have update permissions, Access will not be able to update the lock file to register you and so you will again get read-only access.  If someone has something open in design view, you will be forced into read-only mode.

Make sure that you have properly created a FE and a BE.  The BE is stored on a network share and the FE is linked to it.  Each user must have his own personal copy of the FE, preferably located on his C: drive for optimum performance.

If you are sharing the same physical copy of the FE, you will have issues.
If you are using a monolithic app (unsplit), you will have issues.
If you don't have the correct network permissions, you will have issues.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
if the database is on a network drive, then copy and paste to your local drive.  If all is good then it may be a permissions issue on the network -- if not, we can explore further

[editing]
I see Pat has given you some good information too ~
Top Expert 2016

Commented:
right click on the db app you are working on
select Properties > see if the Read only attribute was selected
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
looking into this issue  "Therefore, if you do not have create permissions on the folder holding the database, Access cannot create the lock file and will open it read only.  Same for update permissions."
John TsioumprisSoftware & Systems Engineer

Commented:
Check your antivirus....lately i have locking issues due to antivirus....disable it or better un install it...report back...
Distinguished Expert 2017

Commented:
You can see the lock file be created when you open the database.  For an .mdb it will be samename.ldb and for an .accdb, it will be samename.laccdb

If the lock file doesn't appear, your permissions are incorrect.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
adding on ...

> "Everytime I open a database  the database opens as ready only"

as others have suggested, you can test the file permissions of what you are opening -- and if you have to change them ... where did the database come from?

if from a CD or other read-only media, it may have got the RO (read-only) flag set).

if from an internet resource -- sometime the file is BLOCKED. If this is the case:
1.      right-click on filename in My Computer or File Explorer
2.      choose Properties
3.      check the Unblock checkbox near the bottom
4.      click OK

... or perhaps you are opening the file from email or a ZIP?

in this case, save the file to a local drive and open what you save.
Top Expert 2016

Commented:
<ot>
hi crystal, good morning!!!
</ot>
Jason clarkDBA Freelancer

Commented:
Read-only attribute of the file may be set. This occurs automatically if you use a compact disc-recordableor a compact disc-rewritable to move the file.
Have a look here: https://support.microsoft.com/en-us/help/324666/you-receive-a-you-are-trying-to-open-a-read-only-database-error-message-when-you-open-a-database-that-was-created-in-an-earlier-version-of-access-in-access-2002,-access-2003-or-access-2007

or You may also check this: http://stackoverflow.com/questions/5954982/access-database-opens-as-read-only

Hope it works for you.

Author

Commented:
Thanks, It all was down to folder permissions.
I have no idea how they were reset.
but reset them and works fine now.

Let me in the right direction.

Thanks
Pat

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial