Security Report -Access

  • Thread starter Thread starter arjun.banerjee
  • Start date Start date
A

arjun.banerjee

I am trying to create a security log in MS Access 2003. What I am
trying to accomplish is to create a report of all the users who used
the database (i.e. username, data & time).

Ideally, I would liked to have the Windows login as the username.

Any assistance in this matter would be greatly appreciated.

-AB
 
There is code at
http://mvps.org/access/api/api0008.htm
you can use to grab the user's Windows login name.

If you have some form that opens on startup (or create one that is hidden, if need be), you can append the username and use the Now() function for the date/time into a table.
 
Back
Top