Audit Trail (1 Viewer)

[borolee13]

I have a database on a network which is shared by other users.

These users are supposed to use this database monthly to montitor there budgets.

I want to be able to create an audit trail on each time they open the database. I am using the OSUserName function to get there netwotk login id.

Can someone give me some code to put in the db so that when it opens, it inserts the user,date,time in and audit table.

i can then ask users who are not using the system, why not.

Many Thanks,
Lee

 

[The_Doc_Man]

Search this forum for the following topics:

Audit Trail
Startup Forms
Login (or Logon) History

The search function really works and the topics you discussed have been addressed. Rather than try to remember all of the details to re-invent this wheel, I invite you to just search for the topics in question.