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:

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

13 thoughts on “Microsoft Access Split Databases: Automatically Re-Link

    Waqar Shah

    (May 17, 2018 - 5:26 am)

    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?

    hassan kadhum

    (May 17, 2018 - 5:26 am)

    Thank u sir for nice video i will test this thanks

    Aza Shukri

    (May 17, 2018 - 5:26 am)

    What a fantastic video.

    Saketh Sharath Reddy

    (May 17, 2018 - 5:26 am)

    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?

    Anna Rocha

    (May 17, 2018 - 5:26 am)

    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.

    Anna Rocha

    (May 17, 2018 - 5:26 am)

    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?

    VFX masters

    (May 17, 2018 - 5:26 am)

    great video but could i ask for a txt of the codes please

    Ross Waddell

    (May 17, 2018 - 5:26 am)

    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?


    (May 17, 2018 - 5:26 am)

    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 ?

    john watkins

    (May 17, 2018 - 5:26 am)

    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

    Luis Cruz

    (May 17, 2018 - 5:26 am)

    question away from the topic

    how can i reset the autonumber from my tables.

    i know there is a a vba code or any other way

    please help

    vic k

    (May 17, 2018 - 5:26 am)

    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?

    janez novak

    (May 17, 2018 - 5:26 am)

    Just great approach, excelent, thank you

Leave a Reply

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