Database sign-on defaulting to wrong user

[angelah100]

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

[ranman256]

user id can be grabbed when the form loads

txtUser = Environ("Username")

[angelah100]

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...

[angelah100]

I think I might have answered my own question - I can use a \user switch (since this is an old database)