Microsoft Access Split Databases: Automatically Re-Link




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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply to Anonymous Cancel reply

Your email address will not be published. Required fields are marked *