Microsoft Access Split Databases: Automatically Re-Link

13
13




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…

13 COMMENTS

  1. If I have two separate split databases with different tables however now I need to link to one table on the second database as it is a large table and needs to be up to date all the time is this possible?

  2. Sir, i honestly am very happy to see this code. i have got it to work i guess upto 50% i have a error kindly guide me.
    i have a "modrefreshlinks/checkbackend error:0 = " Dont know were its going wrong 🙁 im a newbie so please help?

  3. Thank you so much, I figured that out. I added it to my login form. I can't seem to make this work for any other machine. I've tried on different computers and it will only work on mine. Is there away we can talk. I'd be more than happy to compensate you for your time.

  4. Hello,Thank you for this very useful video. I need to open a login form after the splash screen runs but can't seem to make that happen. Would you mind pointing me in the right direction?

  5. I'm using Access 2016 and after I link a table (whether creating a new link or refreshing the connection info on an existing linked table) it shows up as read-only when I open up the table. Programmatically, I appear to be able to update/insert but not through the standard table view. Intermittently, a linked table will open normally and show the (new) record at the bottom of the table, but not frequently. Any ideas?

  6. Thanks very much for this tutorial.
    Sad news for me, after i tried i get the message "Relink successful "when both front and back-ends are in the same folder
    But I get the error "modRefreshlinks/Checkbackend error : o ="
    Please what could be the problem ?

  7. im kinda a noob to access databases, i have built a couple previously, but now i wanna split the databases. i understand some vba code but would like it broke down a little further pls thx for the great video

  8. Great job, Thank you for your clear  descriptions of the process of the code. There are many great sources out there but none that i have found explain and teach me the way your videos do. again great job and keep it up. one question though, can this code pull the text file information from within the front end say from a table so that i don't have a text file that end user could possible see and alter?

LEAVE A REPLY

Please enter your comment!
Please enter your name here