Event procedures for tables modifications

[kerrj]

This is my first post. I don't use Access every day. What I want to do somehow in Access is what can be done in SQL Server. Specifically, triggers. I've got an Access table that is hooked up to an application. When users make changes in the application GUI, a table record either gets updated/inserted/deleted. When any of these events occur, I'd like to write information to some sort of 'Log' table that I will soon create. Is something like this possible?

 

[Jack Cowley]

An Access table has no 'triggers'. You will have to do what you want via a form and then you can add data to any number of tables using 'triggers' and code in the form.

hth,
Jack

 

[kerrj]

if i use a form, the form has to be open and active in order to have the 'trigger' work, right?

 

[Jack Cowley]

Right!

 

[kerrj]

damn!...thanks for your help