Trigger for Audit Tables

[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

 

[John Vinson]

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

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.