Home All Groups Group Topic Archive Search About
Author
20 Sep 2006 8:31 PM
Billy
Hi People,
I am wondering if there is a way to audit access database and be able
to track down who used the database, what changes were made and the
time changes were made.  This is a feature in many database
applications and I am wonder if this can be done in Access.  I know you
can check who is logged in.
Anybody please advise
Billy

Author
21 Sep 2006 1:24 PM
Joan Wild
You can only do this if you've set up the necessary code/tables to track it
beforehand.

See Creating an Audit Log
http://allenbrowne.com/AppAudit.html

I'm not positive that URL is correct, but you'll find an audit trail sample
somewhere on Allen's site
www.allenbrowne.com

--
Joan Wild
Microsoft Access MVP

Billy wrote:
Show quoteHide quote
> Hi People,
> I am wondering if there is a way to audit access database and be able
> to track down who used the database, what changes were made and the
> time changes were made.  This is a feature in many database
> applications and I am wonder if this can be done in Access.  I know
> you can check who is logged in.
> Anybody please advise
> Billy
Author
21 Sep 2006 6:05 PM
Billy
Thanks a lot Joan, you have been of great help.  The coding on that URL
look overwhelming but, I will try it out and see what I come up with.
I am glad I can do this.
Billy
Joan Wild wrote:
Show quoteHide quote
> You can only do this if you've set up the necessary code/tables to track it
> beforehand.
>
> See Creating an Audit Log
http://allenbrowne.com/AppAudit.html
>
> I'm not positive that URL is correct, but you'll find an audit trail sample
> somewhere on Allen's site
www.allenbrowne.com
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Billy wrote:
> > Hi People,
> > I am wondering if there is a way to audit access database and be able
> > to track down who used the database, what changes were made and the
> > time changes were made.  This is a feature in many database
> > applications and I am wonder if this can be done in Access.  I know
> > you can check who is logged in.
> > Anybody please advise
> > Billy