By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Access 97 event logging

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <sh*******@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.