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

How To Fix Access Linked Table Manager Not Working Error

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

The main task of the Linked Table Manager is to help the user to relink Tables In Access whenever changes are 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 infill you with complete information about it. Apart from that, we will also discuss how to fix Access 2016 linked table manager not working issue.

Best Software To Fix Access Linked Table Manager Not Working Issue:

In most cases, the linked table manager stops working due to the occurrence of some corruption issues in the database. To deal with such cases easily and effortlessly, it’s highly recommended to use the Access database repair N recovery tool. This tool works great to resolve any kind of corruption glitches that occurred in your database.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB, $79 USD), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

Why To Choose Access Database Repair N Recovery tool?

  • Repair lost, deleted, damaged or corrupted Microsoft Access database with ease.
  • Successfully repair all types of MS access files mdb, accdbaccde, or mde.
  • Save all your valid data into a fresh new error-free file.
  • Recover attachment fields, table, Visual Basic,  field properties, forms, macros, and much more.

Steps To Use MS Access Repair and Recovery Tool

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 versions of Access Linked Table Manager works differently. Such as in the Office 365 application, users 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 performs so many tasks for you. Let’s know what are those:

  • It is used to fix Access linked table not updating issues along with the structural changes from the source table.
  • Users can also make use of this feature to export a list of linked tables to their Excel application.
  • Make it easy to manage linked tables in Access. this includes tables that are linked to some another source or the tables which are linked like a portion of the split Access database.
  • Users can take benefits of Linked Table Manager also when the 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 the 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 their 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 change in the name of the table or the new credentials. To resolve this issue, you need to relink the Access table or data source.

  1. Tap to the Refresh option again and again until each of the failed status showing the 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 their 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 a 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 a 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 showed “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 the 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 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, the 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 for 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 their 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 the 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 the 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 is showing ‘failed’ status. Access will automatically refresh the status of 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 the Access database, then let us know. Ask your queries in our comment section, we will try our best to provide you the most appropriate solution.

tip Still having issues? Fix them with Stellar Repair for Access:

This software ensures seamless repair & recovery of ACCDB & MDB database and restores all objects including tables, reports, queries, records, forms, and indexes along with modules, macros, etc. Fix Microsoft Access issues now in 3 easy steps:

  1. Download Stellar Access Database Repair Tool rated Great on Cnet.
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

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.