By Richard Rost 2 years ago
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 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Relink Tables
Get notifications when this page is updated