Others

Fix Missing SQL Server Tables in Microsoft Access ODBC Links

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

The user needs to link SQL Server tables that do not appear in the Microsoft Access ODBC table selection dialog.

Fix Missing SQL Server Tables in Microsoft Access ODBC Links
Product
Microsoft Access and SQL Server
Device & OS
not provided
Scenario
An Access database connects to SQL Server through ODBC, and the user wants to link tables they created.
Observed behavior
The connection succeeds and some dbo tables appear, but the user's tables are missing. Both 32-bit and 64-bit ODBC data sources have been tested.
Before you start

Confirm the SQL Server instance and the name of the database that contains the missing tables. Have the appropriate Windows or SQL Server credentials available for the ODBC connection.

Solution 1Recommended

Select the Correct SQL Server Database in the ODBC Connection

Use this when Access connects successfully but the linked-table list may be showing tables from the wrong database.

1
Start the link

In Access, open the database and select External Data > New Data Source > From Other Sources > ODBC Database. Choose the option to link to the data source by creating a linked table.

2
Configure the data source

In the Select Data Source dialog, choose an existing data source to configure, or select New to create one. Select the SQL Server instance and enter the required authentication details.

3
Choose the database

In the ODBC configuration wizard, find the default database setting and select the database that contains your tables from the drop-down list. The setting may be labeled Change the default database to; its location varies by driver.

4
Link the tables

Finish the ODBC configuration, return to the Access Link Tables dialog, and select the tables you need. Open a linked table to confirm that you can read the data.

Select the Correct SQL Server Database in the ODBC Connection
A successful connection is not enough: The connection can succeed while pointing to a different default database. Write access also depends on the SQL Server account's permissions.
Free Microsoft Office alternative

Work With Exported Table Data in WPS Spreadsheets

WPS Office is a free, lightweight alternative for everyday document and spreadsheet work. Its familiar interface and Microsoft Office format compatibility make it easy to move exported data into a spreadsheet workflow. It does not fix Access ODBC connections.

Review and analyze SQL Server data exported to a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can Access connect to SQL Server but not show my tables?

The ODBC connection may be using a different default database, or the login may not have permission to see the tables. Check the database selected in the ODBC configuration and ask an administrator to verify table access.

Do client computers need SQL Server Management Studio?

No. Client computers need Access, an appropriate SQL Server ODBC driver, connection details, and network access to the server. SQL Server Management Studio is useful for administration but is not required to use linked tables.

Which ODBC driver bitness should I use with Access?

Use an ODBC driver and data source that match the bitness of Access, not necessarily the operating system. In Access, check File > Account > About Access to see whether Access is 32-bit or 64-bit.

Can another computer use the same Access front end?

Yes, if it has Access, a compatible ODBC driver, suitable credentials, and network access to SQL Server. A file DSN can help with deployment, although the driver and connection requirements still apply on each workstation.

Should I change firewall settings if some tables already appear?

If the connection already works, first check the selected database and table permissions. Firewall and SQL Server network settings are more relevant when a computer cannot connect to the server at all.