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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
