Custom Access 2003 Login Form

[Steve]

Hi All,



I would really appreciate some help with the following:



I would like to create a custom login form to be displayed when

a user opens an Access database. The form should have a drop

down box linked to an employees table. The combo box should

display both the first name and last name of the employee. In the

employee table both the first name and last name are stored as

separate fields. Lastly, the form should have a text box for the user

to enter a password.



Any suggestions on how to accomplish the above?

I am relatively new to Access so please provide very detailed

responses.



Thanks,



Steve

 

[TC]

You do realize that anyone could just link to that table in your
database, and freely view/add/edit/delete records? So it does not
actually give you any security, at all. Anyone with a basic knowledge
of Access could freely view/add/edit/delete the passwords.

HTH,
TC

 

[jacksonmacd]

As an alternative, you should consider implementing User Level
Security. It's a bit of a learning curve, but more robust than any
roll-your-own system that you might devise. You can find links to
documentation / instructions on the website in my signature.

Hi All,



I would really appreciate some help with the following:



I would like to create a custom login form to be displayed when

a user opens an Access database. The form should have a drop

down box linked to an employees table. The combo box should

display both the first name and last name of the employee. In the

employee table both the first name and last name are stored as

separate fields. Lastly, the form should have a text box for the user

to enter a password.



Any suggestions on how to accomplish the above?

I am relatively new to Access so please provide very detailed

responses.



Thanks,



Steve

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security