Re: Keep track of table changes

[Guus van Velthuijsen]

1- Add a timestamp field to your table(s).
Add a table to store the timestamp you last checked for updates.
According to your current timestamp you can retrieve all records between the current timestamp and the one you stored in your new table. Voila.
Update timestamps in new table.
2- Depends what version you use. Add insert triggers to all your tables and store added key in a new table. Query this new table to retrieve all new records. Voila.
Empty new table.

Grtz,
Guus