I want to create a loop in an Access Data Project that will create a standardized trigger for each table (in a specific SQL Server database) that will
1. keep track of who last changed the record
2. keep track of when the last record was changed.
3. record the previous information in a history table
I am not familiar with how to create a trigger programmatically.