Allen Browne's Audit Trail module question

  • Thread starter gmazza via AccessMonster.com
  • Start date
G

gmazza via AccessMonster.com

Hey there,
I have a different question about this module.

I added this module to my database and it works perfect.
I tried to add another Audit Trail module for a different table as it only
works for 1 table, and I changed the names of the tables again, etc but when
I tried an update I received no error but nothing got inserted into the
audTmp table. I then re-tested my first Audit Trail module and made a change
on the form related to that module and now it doesn’t work anymore. If I get
rid of the 2nd Audit Trail module it works again. Do you know of a reason
adding a second Audit Trail module would cause things not to work with no
errors?
Thanks for your help!
 
R

ruralguy via AccessMonster.com

What do you mean "it only works for 1 table"? Allen's site states:

For each table you wish to audit, you will create two more tables, as follows.
If your database is split into two mdb files, the table created at step 2
must be in the code mdb (workstation file), and the table at step 5 in the
data mdb (server file.)

That sounds like it can handle more than one table to me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top