Results 1 to 8 of 8
  1. #1
    usfarang is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2021
    Posts
    42

    Remember Me on Login Form


    No problem implementing this feature but wanted to know how you can address the security settings since they are set via the frmLogin. Remember Me bypasses that form so ?
    Looking for ideas of how to accomplish getting the users security clearance using this feature.
    Thanks,

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    What is "Remember me on Login Form"? Are you talking about this: https://www.youtube.com/watch?v=oPpv12s_gsM?

    Did not spend the time to watch the video to the end but that is just a customization that he did; you would need to take it further if it doesn't match your needs.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    usfarang is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2021
    Posts
    42
    Yes, remember me bypasses the logon screen and opens your main form, supposedly with you security settings. That is the issue. Working on it but no success as of now.
    Easily implement it but the security settings are a different matter. I did open the Login form hidden and copied the username and password to a different table to compare but that's as far as i have got.

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    So, if you set your security settings in your Login form, you need to adapt the code to not open the main form directly but the Login one, populate it with the saved credentials and trigger the same code as you would have populate it manually.
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    usfarang is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2021
    Posts
    42
    Excellent idea. I made that work.
    Thanks,

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I disagree with the idea behind this.
    Either use a login form for additional security or (better) another approach such as active directory.

    If your database is just used by one person, then why use a login form?
    If it is run in a multi user workplace, then don't allow it to be bypassed
    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
    usfarang is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2021
    Posts
    42
    It's not bypassed, just the luxury of not having to login is all. Security is still in place. Took me a while to figure this out. Very easy to do with no security, not easy with security. It can be turned on and off as they wish.

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I understand how it works and had something very similar over a decade ago.
    I removed the feature as it meant people could login with the credentials of another user on a different workstation...so security was being bypassed.

    If it seems OK for your situation then fine, but I would still avoid it in a multi user environment
    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

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

Similar Threads

  1. MS Access can not remember an Azure SQL login
    By EZ Access Gideon in forum SQL Server
    Replies: 2
    Last Post: 10-18-2020, 10:04 AM
  2. Replies: 2
    Last Post: 08-31-2019, 12:08 PM
  3. Replies: 2
    Last Post: 04-17-2015, 10:59 AM
  4. Remember Last Numeric Value on a Form
    By Thermalmonster in forum Programming
    Replies: 9
    Last Post: 07-25-2014, 09:37 PM
  5. Close form but remember record
    By Mclaren in forum Programming
    Replies: 3
    Last Post: 07-10-2011, 12:02 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