 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / February 2006Allowing R/O users access
I have a couple of lulus here but I'll address the other one in "Queries". This one pertains to allowing users with read-only access to use the database whilst a person with admin access is using it. The way it stands right now, if an admin user is in it the r/o user gets a prompt that the DB is locked. Bear in mind, I am only allowed to use system security, NOT Access security. Any takers > I have a couple of lulus here but I'll address the other one in > "Queries". [quoted text clipped - 8 lines] > > Any takers You cannot use file/folder permissions to provide read only access unless you want ALL users to have read only access. For a mixed bag of permissions you have to implement User Level Security. By the way, you should see the inverse as well. When a read only user opens the file first, a person who would ordinarily have full access will not be able to get anything but read only access until all read only users exit.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com >> I have a couple of lulus here but I'll address the other one in >> "Queries". [quoted text clipped - 9 lines] >the file first, a person who would ordinarily have full access will not be >able to get anything but read only access until all read only users exit. My error.... User Level Security is being used. A R/O user being in the DB first doesn't seem to affect admin users... >>> I have a couple of lulus here but I'll address the other one in >>> "Queries". [quoted text clipped - 14 lines] > > A R/O user being in the DB first doesn't seem to affect admin users... Do R/O users have full access to the folder? All users need file create, file modify, and file delete permissions on the folder for Access to be able to properly manage the lcocking file. When a R/O user opens a file already opened by someone with edit permissions the LDB file needs to be modified to reflect the new user. If they have no permission to modify the LDB file then they cannot get into your app. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.