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

Allen Browns audit log - doesn't save the log

P: n/a
I've successfully set up Allen Brown's code for audit logging
(http://allenbrowne.com/ajbAudit.txt), but I think there is something wrong.
It creates only one log of what the user did. The next time the user edit's
or updates the form it will overwrite the previous log record in the table
in the table. So basically my aud table shows only the most recent record
of what the user did. Is it supposed to be like this? I was hoping I could
make it save the log records in my aud table so I could have a record for
each time a user made a change instead of having it replace the previous
log. Any help would be appreciated.

Thanks,
Brad
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
No, that's not the intended results.

The code does delete from the temp table, but not from the actual log. Have
you get this distinction correct?

Until you get it debugged, comment out the error handers, by adding a single
quote to the 2nd line in each function, i.e.:
'On Error Goto...
You will then see any error, and can fix the problems. Once it is working
correctly, remove the quote mark again.

--
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.

"Bradley Burton" <br***********@comcast.net> wrote in message
news:Oc********************@comcast.com...
I've successfully set up Allen Brown's code for audit logging
(http://allenbrowne.com/ajbAudit.txt), but I think there is something
wrong. It creates only one log of what the user did. The next time the
user edit's or updates the form it will overwrite the previous log record
in the table in the table. So basically my aud table shows only the most
recent record of what the user did. Is it supposed to be like this? I
was hoping I could make it save the log records in my aud table so I could
have a record for each time a user made a change instead of having it
replace the previous log. Any help would be appreciated.

Thanks,
Brad

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.