Fix Missing SQL Server Tables in Microsoft Access ODBC Links
Question details
The user needs to link SQL Server tables that do not appear in the Microsoft Access ODBC table selection dialog.

- 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.
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.
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.
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.
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.
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.
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.

Check Table Visibility and Permissions
Use this if the correct database is selected but the expected tables still do not appear.
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.

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.




