USER NAME

[Guest]

How to get the user name from login (Neal). and how to store the no.of login
times?

 

[Rick B]

The following will give you the user name...
CurrentUser()

What do you mean by the number of login attempts? This session? Since the
password was created? In either case, this is not tracked. I don't believe
there would be any way to do this. You could create a table and store the
number of successful logins by your users each time the database is opened,
but I don't know what value that would have for you. If the user fails to
login, then nothing is logged to indicate that as far as I know.

 

[Lynn Trapp]

First of all, you need to implement User Level Security so you could create
usernames that could be tracked. You would then need to create a table to
store each user login (using the CurrentUser() function). Then you could
query that table using the Count() function.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html