Security Report -Access

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
 
J

Joan Wild

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.
 

Ask a Question

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.

Ask a Question

Similar Threads

Windows username - Access Security Log 1
Paste Link and Link Text From Browser to Word 0
Weekly Report 2
Doughnut Chart linked with the slicer in the pivot table 0
How to insert HTML into an Outlook 2021 email 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2002 change report header text 0

Top