Trigger for Audit Tables

  • Thread starter Thread starter Suzanne Lejeune
  • Start date Start date
S

Suzanne Lejeune

I would like to create audit tables for all my main tables. I have found
some code on the internet that says it will do just that. However, I have
never created a trigger before. Can someone provide me with some basic
intructions on how to create a trigger in Access 2002?

Thanks
Suzanne
 
I would like to create audit tables for all my main tables. I have found
some code on the internet that says it will do just that. However, I have
never created a trigger before. Can someone provide me with some basic
intructions on how to create a trigger in Access 2002?

Thanks
Suzanne
Click to expand...

Access 2000 .mdb files (JET databases) do not support triggers. Sorry!

If you have an Access .adp file (with the data stored in MSDE/SQL
Server tables) you can use SQL triggers, but they're not available
otherwise. You'll need to use VBA code in a Form to get the same
effect.
 
Back
Top