Implement event log in application

[Mr. Smith]

Hi.

I'm starting on a new database project, and want to develop robust event
logging this time. In terms of creating log events on all changes done in
the database, either by system or db users. This will be the base for an
"event view" for executives to monitor all changes done to the application.



Do any of you have a "best practice" approach to include logging, or are
there any built in functions I can use?



Environment: Microsoft SQL Server 2005, with MS Access 2003 as application
environment.



Kind regards

Mr. Smith

 

[Doug Robbins - Word MVP]

This is off-topic for a newsgroup that deals with programming in Word.
Posting to an Access newsgroup would be more appropriate if Access is the
database in use.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Mr. Smith]

Sorry about that....
Posted it in wrong newsgroup...