Form_LogIn.mdb

    This sample db demonstrates a log in form with the following options:
    (a) As Administrator.
    (b) As User.

    Max three attempts are allowed. If the correct combination of user ID and
password are not supplied within the max allowed attempts, the database closes
down. If this happens in non-administrative mode, user's account gets blocked.

    To start with, the text boxes for entering user Id & password have light blue back
color.

    If the first attempt fails, a message box regarding invalid combination of user ID
and password comes up. Simultaneously, the back color of text boxes (user ID &
password) changes to light orange, accompanied by a label display (in light orange
back color) notifying that it is the second attempt.

    If the second attempt fails, a message box regarding invalid combination of user
ID and password comes up. Simultaneously, the back color of text boxes (user ID &
password) changes to light pink, accompanied by a label display (in light pink back
color) notifying that it is the third attempt.

    If the third attempt also fails, the database closes down after displaying
appropriate message box. If this happens in non-administrative mode, the user is
notified that the particular account stands blocked and the administrator should be
contacted.

    Simultaneously, the following entries get recorded against this user's account in
the relevant table:
    (a) Field named Blocked (Yes/No type) gets set to True.
    (b) Current date / time gets entered in field named DtLastBlocked.
    (c) Cumulative count of such blockages for this user is entered in field named
         BlockCount. This helps identify repeated defaulters if any.

    If a user with blocked account tries to log in without clearance from the
administrator, he/she is faced with the following as soon as the user Id is entered:
    (a) Text box for entering password gets locked.
    (b) Command button captioned "OK" gets disabled.
    (c) Back color of both text boxes changes to light pink.
    (d) A label with light pink back color gets displayed, notifying that the account
         stands blocked.
    (e) Focus moves to command button captioned "Cancel". Clicking this command
         button results in closure of database.

    On successful log in, appropriate switchboard form (Administrator or User) gets
opened. Particulars of User_ID, LogStatus and ID (PK) get stored in hidden text
boxes on these forms - for further use by the developer as found necessary.

    Facility for change of password is available on both the switchboards (Adm /
User). The Adm switchboard provides the additional facility for blocking /
unblocking of user accounts.

    Note - If the user tries to close the log in form prematurely, by clicking the close
box at top right of the form, it results in closure of database.

5 - Version: Access 2K/XP/2K3/2K7 (Access 2000 File Format)

Download Access 2K/XP/2K3/2K7: uploads/37/Form_LogIn.zip