How To Fix Access Linked Table Manager Not Working Error

Do also find the task of managing linked table in Access database quite cumbersome? To make this task a bit easier MS Access provide its user with an interesting feature of “Linked Table Manager”.

The main task of Linked Table Manager is to help user to relink Tables In Access whenever changes done in your source database shows effects on the Access linked tables.

Well if you don’t have any idea about linked table manager in Access or how to relink table in Access 2010/2013/2016/2019 database. in that case, this tutorial will surely enfilled you with complete information about it. Apart from that we will also discuss on how to fix Access 2016 linked table manager not working issue.

What Is Linked Table Manager In Access?

In Access Linked Table Manager is the main location to view and manage all the data sources and linked tables present in the database. Being an Access user, you may require to relink, find, edit, delete or refresh the linked table in Access. this necessity mainly generates because of some changes in the data source location, table schema or table name.

Note: on the different version of Access Linked Table Manager works differently. Such as in the Office 365 application, user can use Linked Table Manager to add, search, relink, edit, refresh and delete Access linked tables. But you are not allowed to export information to Excel.

Whereas, in access 2016 or later versions the Linked Table Manager dialog box is very simple. But in this you can export information to your Excel application too.

What Does Linked Table Manager Do In Access?

Linked Table Manager in Access perform so many tasks for you. Let’s know what are those:

  • It is used to fix Access linked table not updating issue along with the structural changes from source table.
  • User can also make use this feature to export list of linked tables to their Excel application.
  • Make it easy to manage linked tables in Access. this include tables which are linked to some another source or the tables which are linked like a portion of split Access database.
  • User can take benefits of Linked Table Manager also when source table definition is changed in SQL Server or some other system.

How To Use Linked Tables Manager In Access?

How To Use Linked Tables Manager In Access

Refresh a data source and its linked tables

For fixing the Access linked table not updating and easy accessing of data source. You need to Refresh a data source with its linked tables. Here is, how to perform this:

  1. Choose the External Data tab and then tap to the Linked Table Manager
  2. In the opened dialog box of Linked Table Manager, you need to choose individual linked tables and its data source.

Well choosing the data source will select all its associated linked tables. you can also expand entries by pressing the (+) sign in the Data Source for choosing each linked table.

  1. Choose the Refresh
  2. If you find a problem with some data source location, then enter the right destination if it is asked or just Edit the data source.
  3. Ensure first that your Status column is visible properly and here check the status of your linked table:
    • Success: this means that your linked tables have been refreshed successfully.
    • Failed: it means that one/more of the linked tables is having a problem.

Well behind the failed status the most common reason is either changes in the name of table or the new credentials. To resolve this issue, you need to relink Access table or data source.

  1. Tap to the Refresh option again and again until each of the failed status showing linked table is been fixed.

Relink a data source or linked table

 Relink Tables In Access

This step will change the data source location and also changes the name of the linked table. So, follow the steps to relink Access table and data source:

  1. Choose the External Data tab and then tap to the Linked Table Manager
  2. In the opened dialog box of Linked Table Manager, you need to choose individual linked tables and its data source.
  3. Well choosing the data source will select all its associated linked tables. you can also expand entries by pressing the (+) sign in the Data Source column for choosing each linked table.
  4. Choose the Relink
  5. When you tap to the relink option, Access prompts you to enter new data source location. After entering the right location either you can change the existing linked table name or assign any new name to it.
  6. Ensure first that your Status column is visible properly and here check the status of your linked table:
    • Success: this means that your linked tables have been refreshed successfully.
    • Failed: it means that one/more of the linked tables is having a problem.
  1. You are asked to assign new table name for your relinked Access table. Whereas in some situations, you have to select a new table from the list of tables.
  1. If you are asked to enter a connection string, then in the connection string box enter the string. Automatically, Access will refresh the status of your linked table from failure to success.
  1. Until the issue get fixed and the status column shown “success”, tap to the relink

Find a linked table

 linked table manager in access

If you are having so many linked tables, then make use of the Search box present at the top of Linked Table Manager to look for the things you want.

  1. Write the name of your linked table in the Search

Access will search out the Data Source Information and Data Source Name columns to get a match as per your search.

Keep it in mind that the search is case-insensitive. Thus, it dynamically lists all the link table name that matches with your search.

  1. For resetting the display once more you need to clear up your Search.

Edit a data source

 manage linked table in access

As per the data source, user can modify the data source path, file name, display name, connection string, password. To perform this, just follow down the steps, mentioned here:

Go to the External Data and then on the Linked Table Manager option.

Tip:

To see the linked table name connection string and other important information. You just need to go to the navigation bar, hover your Mouse pointer over the linked table name.

  1. From the Linked Table Manager dialog box. Choose the data source option and then hit on the Edit.
  2. Make changes in the information already available in the dialog box of Edit Link.
  3. After making complete editing tap to the Finish option.

Delete a data source or linked table

Delete a data source or linked table

Well the need of deleting the data source or linked table mainly occurs when you no longer needed that data source or linked table. Or when you want to remove the clumsiness created by Link Table Manager dialog box.

  1. Choose the External Data tab and then tap to the Linked Table Manager
  2. In the opened dialog box of Linked Table Manager, you need to choose individual linked tables and its data source.
  3. Well choosing the data source will select all its associated linked tables. you can also expand entries by pressing the (+) sign in the Data Source column for choosing each linked table.
  4. Choose the Delete
  5. You will see a pop-up box of confirmation gets open on your screen. In this you need to press the yes option for the deletion of data source or the linked table.

Note: by deleting any linked table you are only removing the information which is needed for opening that linked table in the area of data source. But you are not deleting the table itself.

How To Fix “Linked Table Manager Not Working” Issue In Access?

 Fix Access Linked Table Manager Not Working

Well there are various approaches to fix Access Linked Table Manager Not Working error. So, to solve this issue we just recommend you all to follow the above described solutions in the following sequence.

  1. To get correct links, you need to refresh the data source. This will also help you to fetch the problems causing section more easily.
  2. If you find any issue in the data source, then assign the right location when prompted to enter. Or else make editing of the data source for fixing up the problems.
  3. After then relink Access table that are showing ‘failed’ status. Access will automatically refresh the status to the result of success or failure.
  4. Until and unless the problem of “Linked Table Manager Not Working” is been resolved repeat the steps from 1 to 3.

Wrap Up:

Try this amazing way of Linked Table Manager to manage linked table in Access easily and effortlessly. If you are already using it and rendering Linked Table Manager Not Working error then in that case check out the aforementioned solution.

Apart from this if you find any difficulty meanwhile accessing of the Access database, then let us know. Ask your queries in your FAQ section, we will try our best to provide you the most appropriate solution.

How To Fix Access “Linked Table Manager Not Working” Error?

Avatar

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.