in message
I'm kinda new in access. I'm trying to built a startup form that
incorporates the login user name and passwords of people who access the
database. Can I incorporate that in a form instead to give it a more
professional look
If you set up Access User Level Security (ULS) this is not really possible.
The login screen that appears with a secured Access database comes up
before ANY VBA code runs in the database. So there is no way to have
a form pop-up before the login one which would have a list of users in the
workgroup file.
You can, however, design you own type of security *system* by creating
a table of users and maybe one for user levels. You could then have a custom
made login form be a startup form that could have a combo box list of users
and a text box for the user to enter their password. Through code you could
then give access to various forms and reports. This type of system though is
by no means *truly* secure. Anyone with a little bit of Access knowledge
could circumvent this quite easily. The choice will be yours to make. It all
probably comes down to 'what' you want to protect, and 'who' you want
to protect it from.
If you would like to learn how to setup ULS (which I highly recommend),
post back and I can provide some study links on the subject.
