Results 1 to 7 of 7
  1. #1
    Imagemo is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    May 2019
    Posts
    9

    Login Form with User-Created Passwords

    Hi everyone:



    We've been using an Access Database for a couple years now, but we're trying to add security measures to it by adding a login screen. I know how to create one with a database table set up with user names and passwords, but that's over a 1000 staff members. Basically, I'd like them to go in, create their own login information and then be able to get in from that point. All the info I find online is with a table being set up with usernames and passwords. Unfortunately, they do not have access to those tables, just the forms and reports. They're using Access 2010 by the way if that makes any difference.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    They don't need access to the table, nor should they have it. You can create a form that lets them add their login info. It could be unbound, with the data getting added with an append query or the AddNew method of a recordset. It could be bound and opened to a new record. You could even do it from your login form with a button that adds the data instead of checking it against existing records.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Imagemo is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    May 2019
    Posts
    9
    I will try that...thank you so much.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, post back if you get stuck.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Hmm, perhaps you could modify this...
    https://www.access-diva.com/f11.html

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Hi
    I haven't looked at Gina's example app.
    Here's another example you could adapt for your purposes http://www.mendipdatasystems.co.uk/p...gin/4594469149
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Disclaimer: I'm not saying password logins are not necessary or anything like that, so don't jump on me!
    If you can get by with using Windows LoginID (because users don't share a pc or a Windows session) then consider storing their Windows LoginID in the user table. If not found when they start up they don't get in. Thus no calls to you because someone forgot their password. Plus, any decent password function should include expiry. So if you want to build all that and deal with user calls (or you have no option) then far be it from me to discourage anyone.

    As for the Windows LoginID, you can have the code write it to the table the first time they log in. However, I suspect there already exists some sort of restriction that you've already imposed so that authorized users can't just create a new account.
    Last edited by Micron; 08-13-2019 at 11:57 AM. Reason: clarification
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 9
    Last Post: 11-11-2015, 01:55 PM
  2. Login Form. Passwords work for any User Name?
    By Mtyetti2 in forum Security
    Replies: 3
    Last Post: 01-01-2014, 04:23 AM
  3. User Login Form
    By glen in forum Forms
    Replies: 21
    Last Post: 09-17-2012, 09:09 AM
  4. User Passwords not recognised in Access 2010
    By Philm in forum Programming
    Replies: 2
    Last Post: 05-09-2012, 08:06 AM
  5. Setting up User names and passwords
    By knightjp in forum Security
    Replies: 2
    Last Post: 02-05-2009, 10:18 PM

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