Results 1 to 8 of 8
  1. #1
    meenxip is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    1

    Post Ms-Access 2010 Database user and group level permission

    Dear All,

    I want to set permission for Access 2010 databse object wise, per user or group base.

    I read many links on internet, i am not able to find tool menu for user level security wizard.

    Let me know how the user wise permission can be set for Ms-access 2010 database, for each object. i.e. some user has permission on xyz forms and queries, reports, where as some other user has permission on abc forms and queries and reports.

    Also is it possible without coding? or if i am suppose to write code for it, can you give any sample for it.

    Thanks in advance,


    Meenxip

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    No it can not, natively. This feature set was dropped in 07. Not many really miss it.

    Developers role their own. Set up a UserTable with grouping levels of some sort identified in a permission field for each user.

    Have users log in so their permission level is established.

    Plan ahead so that permission levels is auto entered into appropriate records, queries, etc.

    Hope this helps.

  3. #3
    celito is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    10
    Quote Originally Posted by NTC View Post
    No it can not, natively. This feature set was dropped in 07. Not many really miss it.

    Developers role their own. Set up a UserTable with grouping levels of some sort identified in a permission field for each user.

    Have users log in so their permission level is established.

    Plan ahead so that permission levels is auto entered into appropriate records, queries, etc.

    Hope this helps.
    Thanks NTC for that. I have been struggling myself. It's nice to know that developers don't miss the user wizards in 2007. How is a UserTable, and grouping levels set up? Can't seem to figure this out; some tips would be greatly appreciated.

  4. #4
    celito is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    10
    Just searched around, I think I have an idea now about the UserTable and the login stuff. Thanks NTC.

  5. #5
    Join Date
    Aug 2010
    Posts
    2

    Re: Security

    Yes - as mentioned, dropped as of the 07 version. Security was an ugly monster that most people were not willing to tackle. Much easier to roll your own user tables and control logins yourself!

  6. #6
    focosi is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    97
    ...anyway you could create an empty database on a PC with old version of Access, set user-level security, save as .mdb, and all user-level security settings will be available again when you open the file with Access 2010.
    Be aware that there are softwares (easily available on the web) that can hack user-level security and show users passwords, so Access should never to be considered "safe" !

  7. #7
    zeldakr is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Dec 2012
    Posts
    3
    Yes this was dropped.
    BUT if you do not intend to make use of the new functionality like me as I only do maintenance on old DB.
    I was able to do the following in Access 2010

    Select Menu option File
    Select Menu option Options below the Help
    in the 'Choose commands from' drop down select All Commands
    Scroll down to 'Users and Permissions'

    You will need to add a 'New Group' to the list on the right hand before adding it the the group.
    When done select OK
    Work as per normal Access 2003

  8. #8
    sherryb41 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    17
    thanks zeldakr, I was wanting to know how to do that without using VBA code!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Get User Automatically and Security Level example
    By pkstormy in forum Code Repository
    Replies: 2
    Last Post: 12-10-2015, 12:11 PM
  2. User permissions - access 2010
    By Outlook in forum Security
    Replies: 3
    Last Post: 12-03-2012, 08:19 AM
  3. Replies: 8
    Last Post: 06-30-2010, 10:57 PM
  4. user level security and splitting access db
    By tomClark in forum Security
    Replies: 3
    Last Post: 02-06-2010, 04:28 PM
  5. Replies: 3
    Last Post: 12-08-2009, 01:02 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums