have any records been updated or added?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christopher Glaeser - 13 May 2005 19:18 GMT

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

Reply to this Message

John Vinson - 16 May 2005 01:53 GMT

> 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]

Reply to this Message