G
Giri Palakodeti
We have an Access Front end with linked tables to SQL 2000. There are
some critical tables that are SOX compliant and needs monitoring.
We have Insert/Update and Delete triggers on the criticle tables that
archives the changed records to a table _Archive_tableName
The proble is with Access fron end. Eeven though you are not physically
modifying a record but you open the record from front end and SAVE the record
the trigger fires as if a REAL change happened and wrting a record to archive
table. How can i avoid that?
some critical tables that are SOX compliant and needs monitoring.
We have Insert/Update and Delete triggers on the criticle tables that
archives the changed records to a table _Archive_tableName
The proble is with Access fron end. Eeven though you are not physically
modifying a record but you open the record from front end and SAVE the record
the trigger fires as if a REAL change happened and wrting a record to archive
table. How can i avoid that?