About this tutorial:
Video duration: 30:29
Part 5: Automatically Re-Link Broken Table Links
In this video we will run VBA at application startup to check to see if we still have a good link to our Back-end database. If we do not, we will read a configuration to obtain the location of the Back-end database and we will refresh the connection strings in our linked tables to point to the Back-end.
We will leverage VBA from several previous videos:
Microsoft Access Split Databases: Connection Strings
Retrieving and Setting Connection Strings
Modifying the linkage of linked tables
Writing and Reading…