Solved

Read Only access in Microsoft Access 2007

Posted on 2008-06-12
7
309 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
7 Comments
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 100 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 100 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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 300 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now