?
Solved

Read Only access in Microsoft Access 2007

Posted on 2008-06-12
7
Medium Priority
?
333 Views
Last Modified: 2013-11-29
Currently, I have a Microsoft Access Database 2007.  Multiple people need to access the application at one time, but receive "Read Only" accesss.  Is there anyway to allow multiple users full access?  Thanks.
0
Comment
Question by:OB1Canobie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 400 total points
ID: 21774537
OB1Canobie,

Two reasons this might happen:
1. You are trying to open a DB from inside a zip (compressed file)
2. The file was copied from a CD Rom.

In either case, find the file and right click it.
Select "Properties"
Clear the "Read Only" Checkbox.

JeffCoachman
0
 

Author Comment

by:OB1Canobie
ID: 21774699
Jeff,

neither are the case.  I did right click on the database fiel and everything had checkmarks by them.  The employee has no restrictions.
0
 
LVL 6

Assisted Solution

by:cottsak
cottsak earned 400 total points
ID: 21774931
someone might have an exclusive lock on the file instead of a shared lock (which should be normal). this can be caused by many things. but try removing the file from it's current location or resetting the share if its shared over a network.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21775159
OB1Canobie,

<I did right click on the database fiel and everything had checkmarks by them. >
If "Everything" had a checkmark then  "Read Only" was ON.

Please UNCHECK the Read Only Property, and test for the issue.

JeffCoachman
0
 
LVL 77

Accepted Solution

by:
peter57r earned 1200 total points
ID: 21776541
All users must have full permissions on the folder conatining the access database file(s).
0
 

Author Comment

by:OB1Canobie
ID: 21778052
Peter,

I checked this as well.  My administrator for IT persoanlly reviewed and said all permissions are given to the user.
0
 

Author Comment

by:OB1Canobie
ID: 21782781
I have resolved the issue.  For some reason the server needed to be restarted for the permissions to the folder to be refreshed.  Thanks everyone for your help.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question