Auditing Table Changes

[Tee]

Hi Guys,

Does anyone know if it's possible to audit entries made to MS Acces 97
tables?
I have an excel 97 solution which serves as a front end which writes to the
backend DB. Using Access' white paper, I've secured the database (users need
to logon when starting the process in Excel). What I need to do now is track
changes made to certain tables in the Database.
Any ideas?

Cheers
Tee

 

[Douglas J. Steele]

Take a look at what Allen Browne has at
http://members.iinet.net.au/~allenbrowne/AppAudit.html

 

[Tee]

Hi,

I had previously taken a look a look at Allen Browne's solution but
unfortunately it doesn't resolve my problem. I believe his recommendation is
to trap the changes through the usage of forms.
In this case because the data is being written directly from Excel forms are
not being used.
Any ideas?

 

[Douglas J. Steele]

You're out of luck, then. Unlike other DBMS such as SQL Server or Oracle,
Access doesn't support table triggers. You'll have to add VBA code to your
Excel forms to do the logging for you.