Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Read Only access in Microsoft Access 2007

Posted on 2008-06-12
7
Medium Priority
?
338 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

636 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