Can Access 2007 track who changed an entry last and when it happen

[Ellen]

I am considering to buy Access to be used by a handful of people at work but
I know little about it. If I have a customer entry with many fields
containing different information, is it possible to track when an individual
field was last updated and who did that update?

 

[Arvin Meyer [MVP]]

Use:

http://www.mvps.org/access/api/api0008.htm

to get the name of the current Windows user, and add a timestamp to a date
field in your table. Use the AfterUpdate event of your form to add the user
and date/time info to the table.

Tables have no triggers and therefore require forms to run code.