Refresh All Linked Tables in Microsoft Access 2019
Question details
Refresh many linked tables in Access 2019 without having to confirm each table individually.

- 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.
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.
Refresh tables by source in Linked Table Manager
Use Access's built-in manager to select and refresh multiple links from the same source.
In Access, open the database and select External Data > Linked Table Manager.
Select the linked tables that use the same source. Check the source information in the manager before grouping the tables.
Choose Refresh, or Relink if the source location has changed, and enter the requested file path or DSN information.
Review the status shown in Linked Table Manager and open a linked table to verify that it connects to the intended source.

Consider J Street Relinker for bulk relinking
Explore a third-party relinking utility if Access repeatedly prompts for each table.
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.

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.




