Access databases don't support triggers therefore you cannot log changes at
table level unless you upgrade to SQL Server or MSDE.
However, my suggestion would be to not allow direct access to the tables in
the first place by enforcing Access Security - thus you can then ensure the
user can only enter data via your forms and thus log all changes as you see
fit.
Kind Regards,
Wayne Phillips
http://www.everythingaccess.com - Access Database Repair Service
"Moon_shoes" <shampoo4u@gmail.com> wrote in message
news:1114547209.266135.205040@g14g2000cwa.googlegr oups.com...[color=blue]
> This is what I need:
>
> I need a log of any changes of the information in our database. Can
> this be done at anything deeper than the form level? I need this for
> compliance reasons so in case anyone goes directly into the tables and
> changes data, it will be recorded as well.
>
> Any advice or help is greatly appreciated.
>
> Thank you
>[/color]
