AUDIT LOG

[mcnewsxp]

anybody know a slick way to maintain an audit log?
keep track of who changed what?
tia,
mcnewsxp

 

[Keith Wilby]

anybody know a slick way to maintain an audit log?
keep track of who changed what?
tia,
mcnewsxp

Have a look at "create log table and audit" on the
"comp.databases.ms-access" group.

Keith.
www.keithwilby.com

 

[Cheese_whiz]

Hi m cn,

I used Allen Browne's solution and it seemed to work well. Might be worth a
look.

http://www.allenbrowne.com/AppAudit.html

CW

 

[Keith Wilby]

"comp.databases.ms-access" group.

Whoops, make that "microsoft.public.access.forms".

 

[Linq Adams via AccessMonster.com]

Depends of your definition of "slick!" If you mean "easy" there's no such
critter. If you mean a hack that works as effectively as possible, then
Cheese_whiz's suggestion is about as "slick" as it's going to get. This type
of thing is NEVER going to be simple.