Others

Fix Microsoft Access SQL Server Linked Table Errors 772 and 18

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

Restore access to SQL Server linked tables in Microsoft Access after a move from TLS 1.1 to TLS 1.2.

Fix Microsoft Access SQL Server Linked Table Errors 772 and 18
Product
Microsoft Access and SQL Server
Device & OS
not provided
Scenario
An Access database uses ODBC-linked tables from a SQL Server environment that has changed to TLS 1.2.
Observed behavior
Linked tables may fail to open or refresh, with errors 772 and 18.
Before you start

Confirm the SQL Server name, instance, database, authentication method, and DSN used by the affected tables. In Access, check File > Account > About Access for the application bitness so you can verify that a matching ODBC driver is installed.

Solution 1Recommended

Refresh or relink the SQL Server tables in Access

Use Linked Table Manager to refresh existing links or recreate their connection details after the server change.

1
Open Linked Table Manager

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

2
Refresh the links

Select the affected SQL Server linked tables and choose Refresh. Try opening a table after the refresh completes.

3
Relink if refresh fails

In Linked Table Manager, select the affected tables and choose the relink option. In versions that show it, enable Always Prompt for New Location, then proceed to select or recreate the ODBC connection.

4
Verify connection details

In the ODBC connection or DSN setup dialog, check the server, instance, database, and authentication details. Complete the prompts and try opening the linked tables again.

Refresh or relink the SQL Server tables in Access
Connection options vary: Linked Table Manager controls differ by Access version. A file DSN may simplify deployment; Access may convert it into a DSN-less connection when linking.
Free Microsoft Office alternative

Work with Office files in WPS Office

WPS Office is a free, lightweight alternative for everyday document, spreadsheet, and presentation work. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files. It does not repair Access connections or replace Access linked-table functionality.

Open and edit compatible Word, Excel, and PowerPoint files, including DOCX, XLSX, and PPTX.Use a familiar interface for everyday office tasks.Work with spreadsheet data exported from Access when database connectivity is not needed.Get a free, lightweight office suite for common productivity tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Where is Linked Table Manager in Access?

Open the database and select External Data > Linked Table Manager. The available refresh and relink controls can vary by Access version.

Do I need a 32-bit or 64-bit ODBC driver?

Use a driver that matches Access bitness. Check File > Account > About Access, then inspect the corresponding ODBC Data Source Administrator.

Why does the connection still fail after updating the ODBC driver?

The DSN or linked tables may still use outdated connection details, or the server, network, authentication, or TLS settings may need attention. Test the DSN in ODBC Data Source Administrator and verify the server and database names.

Can a file DSN help when relinking Access tables?

A file DSN can simplify connection setup and deployment. When relinking through Linked Table Manager, select or create the file DSN; Access may convert the resulting link to a DSN-less connection.