Results 1 to 4 of 4
  1. #1
    Outlook is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    4

    Smile User permissions - access 2010

    Hi,



    I'm relatively new to Access but I have setup a database so far without too much trouble, however now I want to set user permissions so that only certain users can access certain objects from a main switchboard.

    How would be the best way? Passwords? User-level security? How do I action either in 2010?

    I have been researching this for sometime now, but all I seem to find is that the 2010 addition prevents User-level security and how to change from previous versions.

    Please help!

    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    As you have already discovered, with ac2010 you need to "roll your own", so to speak.

  3. #3
    DataMuze7 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    1
    Hi - how do I ''roll my own'' security? thanks

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here is a permission set up I use.

    http://www.mrexcel.com/forum/microso...ns-system.html

    It is a lengthy discussion, but it works beautifully when finished.

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

Similar Threads

  1. Access 2010
    By Desstro in forum Access
    Replies: 8
    Last Post: 01-19-2016, 04:09 PM
  2. Macro for user permissions
    By Loisw in forum Programming
    Replies: 1
    Last Post: 10-28-2010, 07:47 AM
  3. User and Group Permissions
    By sdondeti in forum Security
    Replies: 1
    Last Post: 02-01-2010, 05:47 AM
  4. Access 2007 Users and Permissions Problem
    By botts121 in forum Security
    Replies: 3
    Last Post: 07-06-2009, 10:23 AM
  5. Access permissions
    By paulbrog in forum Access
    Replies: 1
    Last Post: 05-05-2009, 11:14 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