How to create a table containing the historical information about who and when modify

[lookingforK]

I am using MS Access 2007 to collect/store/extract data.

I would like to create a table that contains the information about who and when modify the database, i.e. the following table with the fields:

ID


Accessed by
Accessed time
Modified by
Modified time
Last saved by
Last saved time


How to achieve my goal? Should I use VBA?


Thank you in advance.

[ssanfu]

Allen Browne has an example of an audit trail at:

http://allenbrowne.com/AppAudit.html

[lookingforK]

Thank you ssanfu.

Will check ...