User Logon with Combo box?

[Daniel]

I thought I had posted this message already (I appologize if I have but I can't seem to locate it anymore)

Simple question
Is there a way to display a combo box that contains a list of all the database users in the Logon form? Thus a user only has to select the user name form a list instead of entering it manually

Thank you

Daniel

 

[Bruce M. Thompson]

Is there a way to display a combo box that contains a list of all the database
users in the Logon form? Thus a user only has to select the user name form a
list instead of entering it manually.

You cannot modify the logon form. You can, however, and assuming that Access
user-level security has been implemented, include the username switch in the
shortcut on that user's machine (or separate shortcuts on one machine for each
user) so that they will need only to provide the password at logon. The username
switch is:

/user Username

"Username" needs to be replaced with the relevant user's username. Your
shortcut's command line will then be *similar* to the following (it is all on
one line):

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office\Samples\Northwind.mdb" /wrkgrp
"C:\MyMDWs\SecureDB.mdw" /user Charlie