Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

Read Only access in Microsoft Access 2007

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
OB1Canobie
Asked:
OB1Canobie
3 Solutions
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
OB1CanobieAuthor Commented:
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
 
cottsakCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Jeffrey CoachmanMIS LiasonCommented:
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
 
peter57rCommented:
All users must have full permissions on the folder conatining the access database file(s).
0
 
OB1CanobieAuthor Commented:
Peter,

I checked this as well.  My administrator for IT persoanlly reviewed and said all permissions are given to the user.
0
 
OB1CanobieAuthor Commented:
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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now