 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / October 2007refreshing linked tables
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! No, this does not update linked tables. you can use this code to relink tables: http://www.mvps.org/access/tables/tbl0009.htm  SignatureBest regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com >I am building a dbase that has 5 linked tables from other Access dbases >that [quoted text clipped - 11 lines] > > 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. > No, this does not update linked tables. you can use this code to relink > tables: [quoted text clipped - 15 lines] > > > > THANKS! 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 SignatureBest regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com > Hi Alex, > Thanks for your timely response. Maybe my question wasn't very clear. [quoted text clipped - 27 lines] >> > >> > THANKS! 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! > Hi, > actually - there is no need to refresh link in this case, once you open [quoted text clipped - 31 lines] > >> > > >> > THANKS! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.