Solved

How to find out when a Microsoft Access 2002 table was last updated

Posted on 2013-10-25
1
192 Views
Last Modified: 2013-11-08
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,
0
Comment
Question by:672890
1 Comment
 
LVL 5

Accepted Solution

by:
MohitPandit earned 325 total points
ID: 39599803
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question