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

E

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?
 
A

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.
 
Top