Check if a linked table in the database has been updated/changed

  • Thread starter Thread starter CliffKing
  • Start date Start date
C

CliffKing

Is there a way in VBA to check if a linked table in the database has
been updated?
Example:
I have a table "LedgerTemp" which is a direct link to a text file on
the LAN "Ledger.txt"
This text file is periodically updated (overwritten) through out the
day and night by some mainframe jobs.
Right now I just manually run a macro that just basically appends data
from the linked "LedgerTemp" table to a local table "Ledger"

Is there a way I can check to see if my linked table has changed and
if so trigger my macro that appends the new data?

Thanks


Cliff
 
Is there a way I can check to see if my linked table has changed and
if so trigger my macro that appends the new data?
Click to expand...

No.

The mainframe job would need to store the information that it has run
somewhere else so that your database can check. There's nothing in a table to
indicate that its contents have changed.

John W. Vinson [MVP]
 
Back
Top