Display last date linked table was updated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several linked tables in a database. I want to be able to extract the
date the table was last updated into a form or a report. This will allow me
to know if I am working with the most current information. Is there any way
to do this?
 
If you want to know when the last date a structural change was made to the
table it is:
currentdata.AllTables(0).DateModified

If you want to know the last date data was modified in the table, you will
have to design and code that yourself. You can use an audit log (you can
find one on the web), or you can add a field to each table that tells when
that record was last modified, but of course you wont know about deletes.
 
Back
Top