Tracking Valid/Invalid Logins

[TWTTM]

Hello,

I apologize if this is already a thread, but I tried my best to search for it and nothing helped. Alright, I set up low-level security for my database using the security wizard and I was wondering if there is a way to track information (username, date/time, etc.) from the auto-generated logon window. I started out making my own login window, but I couldn't get my permissions set up properly, so I figured the given security measures would be best. Everything works fine, I just need a way to track the logins. Any help would be appreciated, thanks!!

 

[bugsy]

Dim USER
USER = ENVIRON("UserName")

 

[The_Doc_Man]

In general, you can track good logins in a multitude of ways through Access, but only the Windows Application Event Logger will track failed logins. If I recall correctly, Access never "sees" a failed login unless you have written your own login module that kicks in AFTER the user has actually connected to the DB.

 

[TWTTM]

Dim USER
USER = ENVIRON("UserName")

Thanks for that, who knew it was that easy.

In general, you can track good logins in a multitude of ways through Access, but only the Windows Application Event Logger will track failed logins. If I recall correctly, Access never "sees" a failed login unless you have written your own login module that kicks in AFTER the user has actually connected to the DB.

Blah, I figured that would be the case. Looks like I'll have to do this on my own. Thanks for the help.