By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,016 Members | 2,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,016 IT Pros & Developers. It's quick & easy.

MS Access 2002 Audit Log not working correctly

P: n/a
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!

May 3 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Presumably we are talking about this article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

If the error indicates a problem with "duplicates", it would seem that you
have an index wrong in the audit table (or possibly in the temp table.)

The primary key (and possibly other fields) in your original table are
indexed so as to block dupliates. However, these fields can be edited
multiple times, and so there can be multiple entries in the audit table for
the same record in the original table. Make sure the Indexed property of the
fields in the audit table are *not* set to:
Yes (No Duplicates)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<me*********@gmail.comwrote in message
news:11**********************@c35g2000hsg.googlegr oups.com...
>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!
May 4 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.