Microsoft Access Split Databases: Automatically Re-Link

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 https://youtu.be/yIlqUXLzxyo Writing and Reading Sequential Files with Microsoft Access VBA Print # and Line Input # https://youtu.be/uNDQD13ZYao -------------------------------------------- The code listing for this video: http://accessjitsu.com/2016/01/10/microsoft-access-split-databases-automatically-re-link-broken-table-links -------------------------------------------- Videos in this series: Microsoft Access Split Databases: What Are They and Why Do It? https://youtu.be/ZpLfn15jcNs How to Split an Access Database: Two Methods: https://youtu.be/_kMcaAEDu4o Microsoft Access Split Databases: Back-end Passwords: https://youtu.be/uPgBnaGwYjI Microsoft Access Split Databases: Connection Strings https://youtu.be/yIlqUXLzxyo -------------------------------------------- All of my videos organized by topic and other blog topics: http://accessjitsu.com/