Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / April 2007

Tip: Looking for answers? Try searching our database.

setting permissions for different users

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
babs - 25 Apr 2007 21:14 GMT
I had set up 5 users(all that is in the company) (using the User Level
Security Wizard- using the step by step instructions by Joan Wild) so when
they log in from the shortcut on the desktop we can grab their userid.  That
is working fine.  

Now I need to modify the persmissions for the 5 users.  I would like 2 of
the users to have ALL persmission and the rest to only be able to read and
add and edit data - Not modify data design.

I go to Tools, Security, User Group Permissions and reset and apply the
correct permission for each of the 5 people.  However, when I log in under as
the 5 different people - They ALL still have permission to do everything even
though in the User group Persmission is says otherwise,

Any ideas- why is this so confusing?????

Thanks,
BArb

When I go to Tool, Sec
Joan Wild - 25 Apr 2007 21:22 GMT
Although you can manage security by setting permissions on users, it's generally easier to apply permissions to groups.  Then all you need to do is add/remove users from the various groups.

To answer your question, check the permissions of all the groups that each user belongs to.  They will also have the permissions of these groups (you might be confused because these permissions don't show when you look at a specific user, since they are implicit)

Signature

Joan Wild
Microsoft Access MVP

>I had set up 5 users(all that is in the company) (using the User Level
> Security Wizard- using the step by step instructions by Joan Wild) so when
[quoted text clipped - 16 lines]
>
> When I go to Tool, Sec
 
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.