Complex Log in form

[Justin]

I need major assistance. I am trying to build a security log on screen. I got
some assistance yesterday on how to create the form. Now I need to bring it
to the next step. What is required is that:

First off, I need to build a form where the admin of the database will setup
each user.I have a previous form where it is bound to the "employee" table. I
am trying to make it unbound, don't know how to go about it. The fields are
UserName(txt), Password(txt), Security(cmbo), Computer Logon(txt), email
address(txt), SOX(yes/no)[hidden], Date Created(date)[hidden]. Now I need a
way where
there after the admin fills in all data that once the button is pressed, the
data, first looks @ that the table to see if the username and computer logon
is already in the table.
if yes, msgbox should appear saying that it cannot be added and operation
cancelled
if no, data should be added.
Reason why the yes/no box is hidden, once the admin clicks yes, that box
should be checked.

1) When a new user log onto the database for the first time, a popup form
should appear prompting user to enter a new password. Once password has been
stored, password should be updated on that "employee" Table, the date when
the password has been updated should go to a field in the table "Date
Updated" and finally the Main menu should appear

2) For auditing purposes, the password has to be changed every 45 days. Need
a way where when the 45th day arrives, database prompt user to change
password.


3) If user forgets password, I need a way to send the password directly to
their email

Please help!

 

[Roger Carlson]

I have to ask (and maybe this was discussed before), but why don't you use
the built-in Access security? Access security is far from perfect, but it
will do most of what you are looking to do and it will be more secure than
anything you can create. Any security features you can program in Access
will be pretty easy to by-pass by anyone who knows just a little.

See the Access Security FAQ here:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Justin]

Someone recommended the built in security but unfor, my bosses want a
system-made log in with teh requirements below.

I have to ask (and maybe this was discussed before), but why don't you use
the built-in Access security? Access security is far from perfect, but it
will do most of what you are looking to do and it will be more secure than
anything you can create. Any security features you can program in Access
will be pretty easy to by-pass by anyone who knows just a little.

See the Access Security FAQ here:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

I need major assistance. I am trying to build a security log on screen. I got
some assistance yesterday on how to create the form. Now I need to bring it
to the next step. What is required is that:

First off, I need to build a form where the admin of the database will setup
each user.I have a previous form where it is bound to the "employee" table. I
am trying to make it unbound, don't know how to go about it. The fields are
UserName(txt), Password(txt), Security(cmbo), Computer Logon(txt), email
address(txt), SOX(yes/no)[hidden], Date Created(date)[hidden]. Now I need a
way where
there after the admin fills in all data that once the button is pressed, the
data, first looks @ that the table to see if the username and computer logon
is already in the table.
if yes, msgbox should appear saying that it cannot be added and operation
cancelled
if no, data should be added.
Reason why the yes/no box is hidden, once the admin clicks yes, that box
should be checked.

1) When a new user log onto the database for the first time, a popup form
should appear prompting user to enter a new password. Once password has been
stored, password should be updated on that "employee" Table, the date when
the password has been updated should go to a field in the table "Date
Updated" and finally the Main menu should appear

2) For auditing purposes, the password has to be changed every 45 days. Need
a way where when the 45th day arrives, database prompt user to change
password.


3) If user forgets password, I need a way to send the password directly to
their email

Please help!