Results 1 to 4 of 4
  1. #1
    angelah100 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    3

    Database sign-on defaulting to wrong user


    We have three databases that have user-level security. Each of them has a unique username & password that must be used if the user needs to edit records, otherwise the database can be opened in read-only. Each database has its own security file. Before Access 2016, the username was 'saved' so that when the logon appeared the correct username was already entered and I could just enter the password. Now when I open the database, the username will default to the last one that was used - so if I had opened one of the other databases, the logon will display the wrong username. I can't find any setting in Access 2016 that regulates how the logon username defaults. I can obviously type over the default to enter the correct name but some of the users are getting very frustrated (it's only been 24 hrs since the update) because they think they are opening the wrong database when the username is wrong. Anyone know how to fix this?

    Users all have Win10 and Access 2016

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    user id can be grabbed when the form loads

    txtUser = Environ("Username")

  3. #3
    angelah100 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    3
    The logon dialog window appears before the database opens, and the window is generated by the user-level security feature (which was in older versions of Access) so I don't think I can do it that way...

  4. #4
    angelah100 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    3
    I think I might have answered my own question - I can use a \user switch (since this is an old database)

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

Similar Threads

  1. Sign up/Sorting database
    By aarong1191 in forum Database Design
    Replies: 1
    Last Post: 02-13-2015, 12:37 PM
  2. sign in to access using user name and passwrord
    By Mohammadsharif in forum Access
    Replies: 3
    Last Post: 10-20-2014, 02:35 AM
  3. Student Sign In/Out Database
    By roseannej78 in forum Access
    Replies: 1
    Last Post: 05-21-2014, 02:34 PM
  4. Sign Out and Sign In Student Database
    By jamiers in forum Forms
    Replies: 6
    Last Post: 08-29-2012, 02:03 PM
  5. Replies: 22
    Last Post: 01-25-2011, 11:19 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