> 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
Keith Wilby - 11 Aug 2008 11:01 GMT
> "comp.databases.ms-access" group.
Whoops, make that "microsoft.public.access.forms".
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
> anybody know a slick way to maintain an audit log?
> keep track of who changed what?
> tia,
> mcnewsxp
Linq Adams - 11 Aug 2008 20:17 GMT
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.

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003