Solved

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

Posted on 2013-10-25
1
190 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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now