Not so long ago, I wrote a similar application in Oracle (which is case-sensitive) that had
screens to allow users with admin rights to set up new users. Again, it used the Windows user
name to determine the validity of the user, but the user name was entered by the admin user.
I found myself frequently fielding calls from irate administrators claiming the application
did not work because they had set up a new user who then could not get in. The problem
always came down to the spelling of the user name or its case. One of the ways around it was
to use the Lower function to convert both strings to lowercase before the comparison, but the
spelling issue often was a problem that could not be resolved through code.282 Microsoft Access 2010 VBA Macro Programming