How to find out when a Microsoft Access 2002 table was last updated
Hi All,
I have a MS Access 2002 application that runs with various macros every 6 hours and updates some tables. How do I find out when a table was last updated.
Also, how do I find out when a module or a macro last ran.
This will help me troubleshoot application.
Regards,
In Access, there is no track auto maintains like we have in SQL Server in sys.objects.
But we can achieve with custom coding
please find below link for this.
stackoverflow.com/question
For last run of macro, again need to customize. Please follow below link
http://office.microsoft.com/en-in/access-help/store-the-date-and-time-when-a-record-is-modified-HA010241284.aspx
Best Regards