Access-how to log which user modified the msaccess database

[Sunil Somani]

Dear All,

We have a MS-Access database which is having shared access among number of
users. Now as now we got some data updated and no one is taking responsibilty
that he/she has done it.
We are looking for a way to log all audit activities with user name.
That is if any update, delete, insert etc operations has been performed on
the database we can log the user name along with the operation he/she
performed.

Could you please advise.

Thanks in advance,
Sunil

 

[Steve Schapel]

Sunil,

You can make a table for logging user actions.

If your main data is entered/edited via forms, you can use the After Update
event of the form to add data to the logging table.

If your application includes procedures where data is modified via action
queries or otherwise, via VBA code or macros, then you would need to add
provision to these code or macros to also write to the logging table at the
same time.

It is certainly possible to do what you are asking. But if your application
is at all complex, then it will not be a trivial job to set it up.