Access login files

[trawets]

Hi
I am looking for guidance, I have managed to create a log-in form for
my database ( all credit to http://www.databasedev.co.uk for their
examples).
What I would like to do now is to ask access to keep record of who
logs in and when, also this should only be visible to admin operators
of my database

 

[Allan Murphy]

You could use sql to add the user id, login time and date to a table when
the user logs in.

Allan

 

[trawets]

You could use sql to add the user id, login time and date to a table when
the user logs in.

Allan






- Show quoted text -

Alan
Thanks for your suggestion, could you please point to a example or
tutorial explaining how I might acheive this,
I am a bit of a novice reallt to all things programming and I am not
too familiar with sql.

stewart

 

[Guest]

mr murphy is correct and flexible
i used the same
if you use date / time fields in all your forms which are open,d for users
and also use the login form with login name , password , date / time
and develop an normal select query which will keep record of the login name
and time and the forms he visited and as well .