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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find out what fields have been changed 2
This record has been changed by another user ... 1
Adding Records to multiple tables 5
Insert or update record with vba and ado 2
Adding timestamp code to form with a subform. 1
Query runs perfectly but report pulls wrong information (Acces 2007) 0
Archiving Records in Access DB 4
Adding and Deleting records simultaneously in multiple tables 8

Back
Top