Hello everybody,
I want to take some action everytime a table gets updated. I am not sure 
whether Access has anything like "Triggers" ? If not, is anybody aware of 
a workaround - basically i want to run  a Macro once the table is updated. 
The table gets updated thru a website - n the frequency of update is every 
one hour.

Your help wud be greatly appreciated

Thank u
Viv.

Viv,

<< Iwant to take some action everytime a table gets updated. I am not sure 
whether Access has anything like "Triggers" ? If not, is anybody aware of 
a workaround - basically i want to run  a Macro once the table is updated. 
The table gets updated thru a website - n the frequency of update is every 
one hour. >>

Hmmm... Good one.

I suppose if the web is linked to a table, you can open a database with a 
form that has its recordset set to that same table.  Then you can put code 
on the form's "After Update" event, which would call the macro after a 
record is changed.  You can also trigger the form to fire off the "After 
Update" event automatically every X hours by putting an "On Timer" 
event... just in case.

This would require you to have that database open all the time, though.

Greg