Create a conter to log how many times a user logs onto the database.

[awade]

Good Evening All,

I have made a very simple log on form that requires the user to type in a user name and password. The user name and passwords are stored in a table. New users are added to this table to allow access to the database.

Is there a way I can add a counter to see how many times a particular user has logged onto the database?

Is there a way to make the password expire every 365 days requiring the user to reactivate their account and log in details.

Regards

 

[pr2-eugin]

awade, I would create a new field in the table something like lastUpdated, which will have the first login date.. Which you can use to see if it has been a year.. You do not need a counter..

 

[awade]

Thanks pr2,

I need the counter as way of monitoring usage of the database by user.

With having the password automatically expire after 365 this will allow the administrator of the database to clean up users that don't reactivate their account.

So I really need both.

Regards