access login form

[samia]

Hello,

I've two questions. I created an access login form for username and password right, and its OK. My question is? Is there a way I can get to track the login dates and times? 2ndly how would I create a button for new users... I've already entered some two users. I need to create some button/link or whatever such that if its a new user, a from opens and they type in their desired username, and password which is stored in the tblusers.

Thank you in advance,

Samia

 

[Poppa Smurf]

Login Dates and Times
You will and audit table with the following fields user name,login date and login time. When the user logs in you then add the user name the date of login and the time of login to the audit table.

New User
You have two option
1. An administrator assigns the user name and password.

2. On you login form you will need a button that will open a form for the user to enter the proposed user name and password. Once entered to need to validate that the username is not duplicated, has the required number of characters. The password must be the required length etc.

From my experience it is easier for the administrator to assigns an user name and password to a new user.

 

[samia]

Thanks Poppa Smurf, I'll go with admin issuing usernames. Did you mean I've to create tblAudit?? Didn't quite get you properly.

thanks,

Samia

 

[Poppa Smurf]

If you need to track the login dates and times etc. then you will need a table e.g. Login Audit table etc.