Logging User Actions

Is there a way to log user actions?

What I would like is to be able to log user activities within the database.

The table “tblUserEvents” would contain two fields. Field one “EventTime”
would be a date/time stamp of when the action was performed. Field two
“EventDescription” would be a description of the action performed.

Example 1: the user presses the Add button. The date/time is inserted into
“EventTime” and the words “the user pressed the add button” is inserted into
“EventDescription” field within the “tblUserEvents”.

Example 2: the user presses the Close button. The date/time is inserted into
“EventTime” and the words “the user pressed the close button” is inserted
into “EventDescription” field within the “tblUserEvents”.


I would have multiple events being logged all with their own specific
descriptions.

Thanks

--
Message posted via http://www.accessmonster.com

Re: Logging User Actions

The good news is, you can write VBA code in the event procedures to call
your own event logger. The bad news is, to log events, you have to write VBA
code in the event procedures to call your own event logger. On the other
hand, if you use a third-party add-in such as MZTools or FMS' CodeTools, you
can pre-build logging into the structure of your procedure code and it won't
be much trouble.

I'd suggest you think carefully what additional information you might be
able to use to debug problems... the time and description seem to me to be a
very minimal amount of data to bother logging.

Larry Linson
Microsoft Access MVP


"pushrodengine via AccessMonster.com" wrote in message
news:7df95a69105b2@uwe...
> Is there a way to log user actions?
>
> What I would like is to be able to log user activities within the
> database.
>
> The table "tblUserEvents" would contain two fields. Field one "EventTime"
> would be a date/time stamp of when the action was performed. Field two
> "EventDescription" would be a description of the action performed.
>
> Example 1: the user presses the Add button. The date/time is inserted into
> "EventTime" and the words "the user pressed the add button" is inserted
> into
> "EventDescription" field within the "tblUserEvents".
>
> Example 2: the user presses the Close button. The date/time is inserted
> into
> "EventTime" and the words "the user pressed the close button" is inserted
> into "EventDescription" field within the "tblUserEvents".
>
>
> I would have multiple events being logged all with their own specific
> descriptions.
>
> Thanks
>
> --
> Message posted via http://www.accessmonster.com
>