Displaying table modified date and time on a report

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

Guest

I want to create a report and in order for the user to identify the last time
the table was updated I would like to capture the modified date and time of
the table. The validity of the report is dependent on updates to the table
so this would provide the end user with an idea of whether or not they need
to run the update process to bring the data into a more current status.
 
Are you talking about design changes or changes to the data?

In Access 97, you could read the modified date from MSysObjects table. Start
by creating this query:
SELECT * FROM MSysObjects;
and you can take it form there. Unfortunely Microsoft broke that
functionality when they introduced Access 2000, due to the monolithic save.

If you are talking about the data, Access does not record this for you. But
if all changes are made through forms (not directly through tables or
queries), you can use Form_BeforeUpdate to record the date and time into a
field in the table, and then use:
DMax("MyLastUpdatedField", "MyTable")
 
Unfortunately this is all running through queries controled my a macro. No
forms are used. Also I am using Access 2002 so looks like a dead end to me.

Thanks for the help.
 
Back
Top