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

Audit Trail For Access DB?

P: n/a
I'm trying to find a way to create a logfile or audit trail of changes
we make to selected databases. So if someone changes "David" to "Dave"
I want to log what the change was and date it was made. I found an
example script of this when doing a Google general search, but I
couldn't get the script to work correctly so thought I'd try here.

Thanks,
Darrell

Mar 1 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Not sure why I posted this before searching the group. I see some
other posts on this topic. i too was looking for a plug n play type
thing or a prewritten script. Based on what I see here, looks like
some development is involved in doing this. I'm not a developer though
so, unless I missed something, I may have to skip it for now??

Mar 1 '06 #2

P: n/a
AllenBrowne.com has some items about doing an audit trail, look there.
:) tom

You can also put in a 'LastUpdated' field and have it set to Now()
everytime the form changes, I think it would go in the form's
AfterUpdate event, someone else has stated that this would work.

Tom

Mar 2 '06 #3

P: n/a
Try this from Allen Browne's site
(http://allenbrowne.com/AppAudit.html) - follow the guide/instructions
and you should have something you're looking for.
I mention this because I used it within a database to discover that a
User was doing allsorts of things which they claimed they weren't!!

Hope it helps - but if you're a bit stuck or need guidance shout back
to the group.

Cheers

Phil
ve***@aol.com wrote:
Not sure why I posted this before searching the group. I see some
other posts on this topic. i too was looking for a plug n play type
thing or a prewritten script. Based on what I see here, looks like
some development is involved in doing this. I'm not a developer though
so, unless I missed something, I may have to skip it for now??


Mar 2 '06 #4

P: n/a
Last updated will work, but only if the update is made from a Form. If the
user updates a table from table view, or using a query, it won't be done
automatically.

Larry Linson
Microsoft Access MVP

"tlyczko" <tl*****@gmail.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...
AllenBrowne.com has some items about doing an audit trail, look there.
:) tom

You can also put in a 'LastUpdated' field and have it set to Now()
everytime the form changes, I think it would go in the form's
AfterUpdate event, someone else has stated that this would work.

Tom

Mar 2 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.