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

Cliff:

If you want to see if "Ledger.txt" has been modified since the last time you
ran your macro, then there is a way using VBA (i.e. code in a module).

Do you want a VBA solution?

Geoff


"CliffKing" <Cliff72@xxxxxxxxx> wrote in message
news:550c1031-0c9d-4f41-82ce-6737d2569af0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Loading