have any records been updated or added?

  • Thread starter Thread starter Christopher Glaeser
  • Start date Start date
C

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
 
Is there a timestamp property associated with each table
Click to expand...

Not in a JET table, no.
do I need to add this field and maintain the value?
Click to expand...

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