Others

Refresh All Linked Tables in Microsoft Access 2019

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

Question details

Refresh many linked tables in Access 2019 without having to confirm each table individually.

How to Refresh All Linked Tables in Microsoft Access 2019
Product
Microsoft Access 2019
Device & OS
not provided
Scenario
A database contains many linked tables that need to be refreshed or relinked after connection information changes.
Observed behavior
Access may display a success message and a confirmation dialog for each linked table, making the process time-consuming.
Before you start

Identify the data source for the linked tables, such as an Access database file or an ODBC connection, and have the current file path or DSN information ready. Check whether the tables share the same source so you can select them as a group.

Solution 1Recommended

Refresh tables by source in Linked Table Manager

Use Access's built-in manager to select and refresh multiple links from the same source.

1
Open the manager

In Access, open the database and select External Data > Linked Table Manager.

2
Select related links

Select the linked tables that use the same source. Check the source information in the manager before grouping the tables.

3
Refresh the links

Choose Refresh, or Relink if the source location has changed, and enter the requested file path or DSN information.

4
Check the results

Review the status shown in Linked Table Manager and open a linked table to verify that it connects to the intended source.

Refresh tables by source in Linked Table Manager
Confirmation dialogs may remain: Selecting several tables can help organize the refresh, but Access 2019 may still require repeated confirmations for individual links.
Free Microsoft Office alternative

Use WPS Office for Everyday Office Documents

WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format support help you move everyday files between suites. It does not replace Access Linked Table Manager or relink Access databases.

Work with spreadsheet data in WPS SpreadsheetsOpen and edit Microsoft Office formats such as DOCX, XLSX, and PPTXUse a familiar interface for everyday office tasksMove compatible documents between WPS Office and Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Can I refresh multiple linked tables at once in Access 2019?

Yes. Open External Data > Linked Table Manager, select the relevant links, and choose Refresh. Access may still show individual confirmation dialogs.

What is the difference between refreshing and relinking a table?

Refreshing checks or updates an existing link. Relinking lets you point the table to a different source location or connection when the original source has moved or changed.

Should I select tables from different source files together?

For a clearer relinking process, select tables that share the same source file or connection. Check the source information in Linked Table Manager before making your selection.

Can WPS Office refresh linked Access tables?

No. WPS Office can work with Office documents and spreadsheets, but it does not replace Access's Linked Table Manager or refresh Access database links.