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.

[orange]

Please give us the description you would give to a stranger who asked -- What are you trying to do?-- in plain English.

[Missinglinq]

You're talking about creating an Audit Log. Here is an excellent tutorial on the subject:

http://allenbrowne.com/AppAudit.html

Be warned, though, this kind of thing is never going to be a simple task, and you'll need to follow Allen's instructions closely!

Here’s another tutorial, form the Access Gnomes on the Mother Ship

http://support.microsoft.com/kb/197592

The same caveat applies to this example, as well!

Linq ;0)>