I need to keep an audit of records deleted in a table. I would like to make use of Access 2010 Data Access Macros for this!
In the table tblProduct I have a field ProductId
Users need to log onto use the database so I know the user ID and would like to keep this in the audit.
How do I use Data Access Macros to record the ProductId, UserId, Now() in an audit table (tblProductAudit) everytime a record is deleted in tblProduct?
In the table tblProduct I have a field ProductId
Users need to log onto use the database so I know the user ID and would like to keep this in the audit.
How do I use Data Access Macros to record the ProductId, UserId, Now() in an audit table (tblProductAudit) everytime a record is deleted in tblProduct?
