Auditing! Never an easy thing to do. I need to report changes made by Access queries on two access tables. Unless anyone has other suggestions I'd like the Audit tables to be separate for each table. One for the Policy and one for the Clients:
PolicyID or Client ID (Unique key on the tables that are updated)
New records do not need to be reported. Modified records that have most but not all columns that changed need to be captured. And only if the Policy is of a certain status (i.e. there is a record on another table with the PolicyID as Status = "IN PROGRESS" on that other table) does it need to have the changes captured for auditing. This is strictly for the tables that are updated using an update query. Also if the Policy or Client is deleted and the Policy was that certain status I need to have that reported as well. There are no changes via forms so Allen Browne's procedure (http://allenbrowne.com/AppAudit.html
) while great is not useable here. Anyone have any ideas or suggestions? Any links or discussion groups?