From the course: Building Solutions Using Excel and Access 2019 Together

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Work with the Linked Table Manager

Work with the Linked Table Manager

From the course: Building Solutions Using Excel and Access 2019 Together

Start my 1-month free trial

Work with the Linked Table Manager

“

- [Instructor] When you work with linked tables, just remember it requires a certain level of maintenance, especially if files get moved, and another important factor in this course is if you've jumped in at any point you might need to link table manager in order to update your database. Let's go take a look at the Linked Table Manager. I'm in my database and I'm going to hover over my department list and it shows me the link to my file. Your link will look like your link that you established. I'll go ahead and click on that. Now I know that it's a linked table because I can see the little blue arrow. They all have a little bit different icon, depending on what you linked in. Alright, I'm going to right click the department list and go to the linked table manager, but before I do, let me show you two other options. Refresh link, this actually forces the data to refresh, so if something changed in the last second or two, you can go ahead and refresh it. And then you also have Convert…

Contents