Relink Tables when your Back-End has Moved

In this video, I will show you how to relink the tables to your back-end file in Microsoft Access, should the location of that table move. We'll see how to use the Linked Table Manager to relink the file.

Nicholas from Baltimore, Maryland (a Platinum Member) asks: I recently installed a new file server. This involved moving everything around, including my Access back-end database file. I split my database like you instructed in your video. Now, I'm getting a run-time error 3024 with Access saying it can't find the file. How do I fix this?

Members

Members will learn how to relink the back-end file automatically using a little VBA. This way, your users and you don't ever need to use the Linked Table Manager. We will prompt them and ask for the new location by having them browse to it. 

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Split Database: https://599cd.com/Split
• Error Handling: https://599cd.com/ACD15
• TableDefs: https://599cd.com/ACD26
• Relink with VBA: https://599cd.com/ACD33

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, external data, linked table manager, data source name, data source information, runtime error 3024, runtime error 3044, relink, different names, mde file, tabledef, tabledefs, pickfile, relink tables vba, vba relink tables, manage linked tables, automatically relink microsoft access tables, how do you relink a table, modifying linked tables, update linked tables, link to table vba