I have an Access database that has external links to a network drive where a .txt file is posted weekly with sales information when they become available. The filename of the .txt files are related to the week of the fiscal year (ex. report_200444 for week 44 of 2004 then report_200445 for week 45 of 2004). I have separate databases for each quarter in a fiscal year (weeks 1-13 for Q1, weeks 13-26 for Q2, weeks 27-39 for Q3, weeks 40-52 for Q4). I have developed queries that looks at the weekly reports (place holder with dummy data) with the same report names.
In the past I have refreshed the table links manually when the week of sales information become available making the query valid. Now I need VBA code that will look to a table of report names that I establish and check the network if the report is available then deletes the place holder with the same name and creates a linked table.