Triggers within ACCESS (audit trails)

[Graham]

I have a bespoke 3rd party application which uses Access
as a backend and I wish to track all inserts, updates and
deletes that it performs. I tried putting the DB into SQL
server then linking the tables back into Access for the
app to use. This allowed me to populate audit tables
using individual and conditional triggers for inserts,
updates, and deletes. Almost worked except for a few date
format issues in the SQL code generated by the app

Is there a way in which I can use triggers or events to
trap when a record is written edited or deleted within a
normal MDB access database ?

I'm ok on what I want to capture, I just need the pointer
on what to use as the event that triggers the audit
process.

Many thanks in advance.

Graham

Graham

 

[Brendan Reynolds]

No. Jet does not support triggers, and tables do not fire any events. If the
application was an Access application, you would use VBA code behind the
data entry forms to capture this information, but as it is a third party
application, it is a question of convincing the third-party developers to
add the feature to their application.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.