Log denied access

[Jonathan Brown]

Is there a way I can create a table called tblAccessDenied and have it log
any denied login attempts to a database using user level security? I'd like
the table to track the attempted username and password, date and time, and
maybe even the IP address or mac address of the machine, or even better the
user account of the person on that machine. Any ideas?

 

[Jeff Conrad]

As far as I know this is not possible because the login screen that appears
with a secured Access database comes up before ANY VBA code runs in the
database. So there is no way to intercept any unsuccessful attempts. I'm
more than happy to be corrected, but I fear not.