Can Access track user changes?

[Guest]

I inherited a database that keeps track of projects and their status. I've
created forms for the users to update portions of the data. I will also
secure the db requiring logins, and will restrict changes to certain logins.
The question is when users login and make changes, is there a process I can
create to ID those changes and mark them with the users name?

 

[Van T. Dinh]

See Allen Browne's Audit Trail:

http://www.allenbrowne.com/AppAudit.html

 

[aaron.kempf]

MDB is CRAP

use ACCESS DATA PROJECTS you can use real triggers; much better solution