Hello,
I have a database with a number of linked tables that are linked to tables in different databases (not a back-end)
for example,
I have table1 that is linked to table1 in K:\database\db1.mdb.
table2 linked to table2 in S:\data\data.mdb.
and so on...
However, recently we have moved all our databases to a new location.
K:\database\db1.mdb is now residing in O:\master\database
and S:\data\data.mdb is now residing in O:\master\data
and so on...
I'm now in charge of relinking all those tables to point to the new location.
I would do this in linked table manager one by one but we have 100s of tables linked to multiple different databases in different location.
My question is,
is there a way to create a VBA code that will automatically do this re-linking process?
so,
1. find unlinkable tables
2. search its new location under O:\master
3. re-link it to the new location
Database names and tables names have not been changed. Just the location of databases.
Thank you in advance,