Tracking Database Usage

[Guest]

Is it possible or has anyone built a subrouttine??? that automatically tracks
the usage of a database (user, date/time, etc.,)?

If not does anyone have any idea how to accomplish this task?

 

[dbwiz.com]

Does your access DB have a switchboard? If so, code an "Insert Into"
statement on the OnLoad event of the switchboard. That way you can
load the kind of information you want to capture. Possibly with Dates
and UserName, if thats how users login.

Thanks,
www.dbwiz.com

 

[Guest]

dbwiz - Can you post code for that?

Does your access DB have a switchboard? If so, code an "Insert Into"
statement on the OnLoad event of the switchboard. That way you can
load the kind of information you want to capture. Possibly with Dates
and UserName, if thats how users login.

Thanks,
www.dbwiz.com

 

[Guest]

Hi,

If you could show how you might go about acheiving something like that, it
would very useful.
I want to track the usage of my database, but how one would go about
acheiving something like that I am not sure. Hence, your idea and method
sounds quite useful.

Many Thanks
Kieron White