Others

How to Fix Access Linked Tables That Fail Outside the Local Network

Maira Mehtab Oct 12, 2026 869 views

Question details

The user needs to fix an MS Access linked-table connection to a SQL Server database that functions correctly on a local network but fails when accessed over the internet.

How to Fix Access Linked Tables That Fail Outside the Local Network

Product: Microsoft Access / SQL Server
Device & OS: not provided
Scenario: Attempting to query or connect to SQL Server via MS Access linked tables using a public WAN (internet) IP address.
Observed behavior: The linked-table connection succeeds on the local network but throws a connection error or times out when connecting from outside the local network.

Before you start

Verify that your SQL Server's public IP address is correct and ensure your network administrator has forwarded TCP port 1433 through the firewall to the SQL host machine.

Solution 1Recommended

Explicitly Specify the SQL Server Port in the Connection String

Modify the server address in your ODBC connection setup to include the exact SQL Server port, forcing the connection to route properly over the public internet.

Local networks can often resolve SQL Server connections automatically without explicit port declarations. However, external connections over a WAN require the exact port to bypass firewalls and reach the destination server successfully.

Open Linked Table Manager

In Microsoft Access, navigate to the 'External Data' tab on the ribbon and click on 'Linked Table Manager'.

Prompt for New Location

Select the SQL Server tables you want to reconnect, check the box labeled 'Always prompt for new location' (or 'Relink'), and click 'OK'.

Update the Server Address

When the SQL Server ODBC dialog appears, locate the 'Server' field. Change the IP address to include a comma followed by the port number. For example, change '67.xxx.xxx.163' to '67.xxx.xxx.163,1433'.

Enter Credentials and Complete

Provide your SQL Server authentication credentials, click 'Next', and finish the wizard to test and establish the linked-table connection.

Explicitly Specify the SQL Server Port in the Connection String

Enable SQL Server Authentication: Ensure that your SQL Server is configured to accept 'SQL Server and Windows Authentication mode' and that TCP/IP protocols are enabled in the SQL Server Configuration Manager.

Free Microsoft Office alternative

Looking for a Lightweight Alternative to Manage Your Data?

While Microsoft Access is built for complex relational databases, most daily data management tasks can be handled efficiently with spreadsheets. WPS Office provides a free, lightweight, and highly compatible alternative for organizing, analyzing, and sharing your data sets.

1. Download and Install: Get WPS Office for free from the official website and install the suite on your device.
2. Open Your Data: Launch WPS Spreadsheet and open your existing .xlsx, .xls, or .csv database exports.
3. Analyze Effortlessly: Use familiar formulas, intuitive pivot tables, and visualization tools to manage your data without complex database configurations.

Fully compatible with Microsoft Excel (.xlsx) and CSV formats.Lightweight design ensures fast startup times and smooth processing for large datasets.Built-in advanced formulas, filtering, and pivot tables for deep data analysis.Cross-platform support allows you to view and manage your data from Windows, Mac, or mobile.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Access linked tables work locally but not remotely?

Local networks often resolve server names and default ports automatically via local broadcast protocols. Remote internet connections require exact routing, meaning you must provide the public IP address and explicitly state the communication port (like 1433) in the connection string.

What is the default port for Microsoft SQL Server?

The default TCP port for Microsoft SQL Server is 1433. If your database or network administrator configured a custom port for security reasons, you must append that specific number to your server IP address (e.g., IPAddress,CustomPort).

How do I ensure the SQL Server is accessible from the internet?

You need to access your router or firewall's administration panel and set up 'Port Forwarding'. Create a rule that directs incoming TCP traffic on port 1433 to the internal, local IP address of the machine hosting your SQL Server database.

Office Quick Solutions