I am using an MS Access 2002 database to track user login
information. I have copied Allen Browne's audit log and removed the
references to the error handling.
So far, on all of my forms (for 7 tables), the 'Inserts' are recorded
in the audit tables, but Deletes are not recored and when records are
changed, the "Edit To" shows in the audit table, but there is no "Edit
From" and "Delete" entries show up only in the Temp table.
AudEditBegin, AudEditEnd, AudDelBegin, and AudDelEnd all appear to be
running. I have removed any extraneous code from my forms (I had
checkboxes and buttons to open other forms etc) to eliminate that as a
possibility.
I get an error on Deletes that indicates it cannot finish the
procedure because it would create duplicate values. I have checked
all fields and none are indexed (except primary key). On updates, no
"Edit From" values are logged.
Any help would be greatly appreciated!