database opened as read only

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
LVL 3
FordraidersAsked:
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.

PatHartmanCommented:
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.
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
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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 ~
0
Rey Obrero (Capricorn1)Commented:
right click on the db app you are working on
select Properties > see if the Read only attribute was selected
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

FordraidersAuthor 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."
0
John TsioumprisSoftware & Systems EngineerCommented:
Check your antivirus....lately i have locking issues due to antivirus....disable it or better un install it...report back...
0
PatHartmanCommented:
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.
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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.
0
Rey Obrero (Capricorn1)Commented:
<ot>
hi crystal, good morning!!!
</ot>
1
Jason clarkDBA FreelancerCommented:
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.
0
FordraidersAuthor 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
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.