Hi guys how would you guys implement an audit trail with ASP.<BR><BR>let&#039s pretend that the database consists of 100 possible tables in which the users can put input. what do you guys think would be the best way to implement an AUDIT TRAIL.<BR><BR>my idea is to give the person a session variable when they log on to the ASP application with their password and user id.<BR><BR>then I could add a field to every table in the database and just put their user ID to indicate that that person added that record. i think the record already has a field for date which is set to now<BR>what do you guys think ? <BR>