I have 25 linked tables linked to text files in MS Access. I would like to make a VBA module that will redirect/relink all the tables to a different file extension. Below is a sample of what the linked tables' paths currently look like (there are 25):
C:\External\Company1\Submissions\20120103
C:\External\Company2\Submissions\20120103
C:\External\Company3\Submissions\20120103
C:\External\Company4\Submissions\20120103
C:\External\Company5\Submissions\20120103
The list of all 25 companies resides in a table called CompanyList.
What I would like to happen when I run the module is to have a window pop up where I can edit the final portion of the file extension, e.g. change \20120103 to \20120110 for all 25 linked tables.
I'm thinking something like "C:\External\" + [COMPANYLIST] + \ [input from pop up window].
I use basic SQL coding all the time, but I'm definitely just a beginner at VBA, so any help would be greatly appreciated!
Thank you!