Results 1 to 4 of 4
  1. #1
    johnwatkins35 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Posts
    5

    Multi users login form


    im trying create someting like access 2003, that has multi users with permissions. im trying have say one person login and he onl has read only access and others may have rights to something else. i have 13 teams. each team has 7 dudes. i wanted to have each team view only their own team info. can anyone help me out with this?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,895
    Common topic, search forum or google, keywords: login, user security

    Start with https://www.accessforums.net/showthr...943-User-Login
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    libraccess's Avatar
    libraccess is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Napier New Zealand
    Posts
    129
    Attachment 7646I'm a dummy and I have been able to adapt a login I originally found in UKProgrammers
    This will work . You may need to discard a lot of the extra forms they are there as part of a template
    So the Field [UserID] is the key to restricting users to their own records.
    I'll have a look to see if I can find the original and post it here

  4. #4
    libraccess's Avatar
    libraccess is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Napier New Zealand
    Posts
    129
    http://www.databasedev.co.uk/login.html
    close

    by the way the password in the template is PW

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

Similar Threads

  1. Replies: 10
    Last Post: 03-02-2012, 11:06 AM
  2. Multi- User Login
    By Tom Lovick in forum Access
    Replies: 1
    Last Post: 02-11-2012, 12:20 PM
  3. Replies: 6
    Last Post: 12-12-2011, 01:28 PM
  4. Replies: 7
    Last Post: 06-24-2011, 10:42 PM
  5. Replies: 1
    Last Post: 01-04-2008, 11:40 AM

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