What should I do if my linked table is not working?
Relink individual tables that have a Failed status. Access automatically refreshes the status to indicate success or failure. Repeat steps 1 to 3 until all problems are fixed. Refresh a data source and its linked tables to ensure that the data source is accessible and the linked tables are working properly.
How to delete access to a linked table?
Delete Linked Table in Access 1 Select External Data > Linked Table Manager. 2 In the Linked Table Manager dialog box, select one or more data sources or linked tables. 3 Select Delete. 4 When you are prompted to confirm, select Yes. See More….
How to add a link to a database in Excel?
Select Access, select Next, and then enter the file name and password in the Add New Link dialog box. For more information, see Import or link to data in another Access database. Select Excel, and then enter the file name in the Add New Link dialog box.
How to relink data in linked table manager?
Relink a data source or linked table 1 Select External Data > Linked Table Manager. 2 In the Linked Table Manager dialog box, select a data source or individual linked tables. 3 Select Relink. 4 Whether or not Access locates the data source, Access prompts you for a new data source location.
How to change link string in linked table manager?
Select External Data > Linked Table Manager. Tip In the navigation bar, you can hover over the linked table name to see connection string and other information. In the Linked Table Manager dialog box, select the data source, hover over the data source, and then select Edit. Change the information in the Edit Link dialog box.
How to change the location of a linked table?
Selecting a data source selects all of its linked tables. Expand (+) entries in the Data Source to select individual linked tables. Select Refresh. If there is a problem with the data source location, enter the correct location if you are prompted or Edit the data source.
How to check the status of a linked table?
Expand (+) entries in the Data Source to select individual linked tables. Select Refresh. If there is a problem with the data source location, enter the correct location if you are prompted or Edit the data source. Make sure the Status column is visible (you may have to scroll sideways), and then check it to see the results:
https://www.youtube.com/watch?v=qCms4BJAGC8