Audit Trail For Access DB?

[veaux]

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

[veaux]

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

[tlyczko]

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

[Phil Latio]

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

[Larry Linson]

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