User Accounts

  • Thread starter Thread starter WTC
  • Start date Start date
W

WTC

Is there a way to make a drop down list to select a user name when logging
in a database that uses a workgroup file. So the users of the database do
not have to type in there user name. And when logging into a workgroup
database, can u always have the user name blank instead of the last user
name that was logged.

Thanks in advance.
 
WTC said:
Is there a way to make a drop down list to select a user name when logging in
a database that uses a workgroup file. So the users of the database do not
have to type in there user name. And when logging into a workgroup database,
can u always have the user name blank instead of the last user name that was
logged.

Thanks in advance.
Click to expand...

The only way I would know to do this would be to first open a non-secure app
that doesn't require a login at all. It would display a form with the dropdown
list of users. The user would select their name, enter their password and press
[OK] at which point you would shell the secure app using the UserName and
Password supplied and then have the starter app close itself.
 
In addition to Rick's answer, I feel it important to point out that one of
the principle tenets of security is obfuscation. That's is, if a hacker
can't see it or find it, he can't use it. Providing a list of user names
gives a potential hacker half of what they need to break in.

For example, in a large organisation, there is bound to be at least one
person whose password is "password". If you give a hacker everyone's user
names, then all he has to do is try using "password" with each of them until
he stumbles across one that works. Thanks for all the fish!

I'm sorry, but if your users are so lazy that they complain about having to
enter their user names, then you have more problems in your organisation
than that.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
You can set up a desktop shortcut for each user, using the /user switch to
specify the username.
That way, the user only has to type in the password.
 
Thanks, I think i will keep things how they are with your points. I should
of know about hackers seeing everything,

How about the user name being set to blank when exiting the database.

something like this

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

CurrentUser = ""
DoCmd.Quit

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub

when exiting the database

But this is giving me an error, do you need to have a user name in the user
field.
 
I think your only options are:
1. Leave the Logon dialog as it is.
2. Create a shortcut, and provide the user name as a command line
argument. At least you'd only be providing one user name.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
Thank you for help.

--
William



Graham R Seach said:
I think your only options are:
1. Leave the Logon dialog as it is.
2. Create a shortcut, and provide the user name as a command line
argument. At least you'd only be providing one user name.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Click to expand...
 
Back
Top