have any records been updated or added?

[Christopher Glaeser]

What is the recommended technique to determine if any records of a table
have been modified or added in a multi-user database since the last tick of
a Timer event? Is there a timestamp property associated with each table, or
do I need to add this field and maintain the value? I'm using ADO and
Access 2003.

Best,
Christopher

 

[John Vinson]

Is there a timestamp property associated with each table

Not in a JET table, no.

do I need to add this field and maintain the value?

Yes. And there are no triggers; you'll need to ensure that data is
added using a Form and use the Form's BeforeUpdate event to update the
timestamp.

If your data is stored in SQL/Server then you can of course use
triggers and SQL Timestamps.

John W. Vinson[MVP]