refreshing linked tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a dbase that has 5 linked tables from other Access dbases that
we use in the department.

I would like for the procedure I'm programmin to update the data in the
linked tables every time the script runs.

I have included the following code as the first line of my script.

CurrentDb.TableDefs.Refresh

Will the above code update the linked tables? I can't really tell from my
end if its doing it....please advise!

THANKS!
 
Hi Alex,
Thanks for your timely response. Maybe my question wasn't very clear.

The tables that have been linked to my dbase are dynamic, in that the data
on them will be changing quarterly. I don't need to "re-link" a table as the
link-location won't be changing.

I just need to refresh the link to ensure that I'm analysing the most
current data from the dbase hosting the shared tables.
 
Hi Alex,
So you're saying that simply because the table is a linked table, it will
always represent the most current data present in the host database?

I can dig it... THANKS!
 
Back
Top