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,
672890Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
MohitPanditConnect With a Mentor Commented:
Hello,

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/questions/926897/detect-time-of-last-change-on-a-microsoft-access-database-table

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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.