View Full Version : linked table triggers


alfi
11-14-2008, 08:03 AM
I am looking for a way to identify data change on a linked table; one way is to look at the time stamp of the original file and to compare between the current time stamp and the one that I save in the database, I am looking to find out if there is some kind of a trigger mechanism, thanks guys.

Banana
11-14-2008, 08:08 AM
There is no triggers in Access, though it may be provided by the backend itself.

If you want Access to say, filter on data that was changed, one way would be to get a recordset and hold it persistently, then occasionally run a query to compare the timestamps and see if it is different.