Thank you for your input.

What this means is I will have to run a DMax()
on the timestamp field and a DCount() on the
primary key field, to catch Edited records,
New records and Deleted records.

Running the above every few seconds on the
on_timer event is going to be pretty heavy on
the network, especially since we are talking about
large tables.

I suppose the next best solution would be to trap Edits,
Additions and Deletions on the Form and store the
timestamp in either a custom property on the table,
or create another table especially for this purpose,
and store it there.

I imagine the extra table will be fastest solution.

If you know of anything better please let me know.