refreshing linked tables

[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!

 

[Alex Dybenko]

No, this does not update linked tables. you can use this code to relink
tables:
http://www.mvps.org/access/tables/tbl0009.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Guest]

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.

 

[Alex Dybenko]

Hi,
actually - there is no need to refresh link in this case, once you open
table or query, based on it - you will get latest data

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Guest]

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!