Office Settings & Configuration

How to Connect Access 365 to an ODBC System DSN

Adam DavisAdam Davis Nov 3, 2026 870 views

Question details

The user needs to connect Microsoft Access 365 to an ODBC System DSN but cannot find the System DSN option during setup.

How to Connect Access 365 to an ODBC System DSN
Product
Microsoft Access 365
Device & OS
not provided
Scenario
Setting up a database connection via ODBC Data Source Administrator to link external data into Microsoft Access.
Observed behavior
The System DSN option is entirely missing from the dialog box, showing only File and Machine DSNs. In some attempts, the application closes abruptly or rejects the data source name when trying to complete the connection.
Before you start

Verify whether your Microsoft Access 365 installation is 32-bit or 64-bit, as your ODBC driver and DSN architecture must match the application perfectly.

Solution 1Recommended

Configure ODBC Connection with Administrator Privileges

Run Access as an administrator and ensure the architecture of your DSN matches your Access version to successfully view and connect to System DSNs.

System DSNs are machine-wide configurations that often require elevated Windows privileges to access. If you are launching Access normally, it might lack the permissions required to view or query System DSNs.

Additionally, a common cause for missing DSNs is an architecture mismatch. A 32-bit ODBC driver and DSN will never appear in a 64-bit version of Microsoft Access, and vice versa.

1
Launch Access as Administrator

Close Microsoft Access completely. Locate the Access 365 shortcut in your Start menu, right-click it, select 'More', and then click 'Run as administrator'.

2
Initiate the External Data Connection

Open your target database. Navigate to the 'External Data' tab on the top ribbon, click on 'New Data Source', select 'From Other Sources', and then choose 'ODBC Database'.

3
Select Connection Method

Choose whether you want to import the source data into a new table or link to the data source by creating a linked table, then click 'OK'.

4
Locate the System DSN

In the 'Select Data Source' dialog box, navigate to the 'Machine Data Source' tab. You should now see your System DSNs listed alongside User DSNs.

Configure ODBC Connection with Administrator Privileges
Architecture Match Requirement: If the System DSN is still missing, open the Windows ODBC Data Source Administrator that specifically matches your Access bit-version (search for 'ODBC 64-bit' or 'ODBC 32-bit' in the Windows Start Menu) and ensure your DSN is created there.
Free Microsoft Office alternative

Need a Fast and Reliable Alternative for Everyday Office Tasks?

While complex database management requires specialized tools like Microsoft Access, you might find that for your day-to-day documents, spreadsheets, and presentations, WPS Office is an exceptional choice. It is entirely free, lightweight, and highly compatible with standard Microsoft formats.

  1. 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen prompts to complete the installation.
  3. 3. Start Working Instantly: Open WPS Office and immediately start viewing, editing, or creating your office documents with full format compatibility.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight design that runs smoothly on almost any device without draining system resources.Includes powerful built-in PDF editing and format conversion tools.Features a familiar and intuitive user interface for a seamless transition from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my ODBC System DSN not showing up in Access?

This is almost always due to a bit-version mismatch. If you are using 64-bit Access, you must create the System DSN using the 64-bit ODBC Data Source Administrator. A DSN created in the 32-bit ODBC tool will remain completely invisible to a 64-bit application.

Why does Microsoft Access close unexpectedly when connecting to an ODBC source?

Access may crash or close abruptly if the ODBC driver is outdated, corrupted, or incompatible with your specific Access build. Ensure you have downloaded the latest official driver provided by your database vendor and that it matches your Access architecture.

What is the difference between a Machine DSN and a System DSN?

A Machine DSN is stored in the Windows registry and is specific to that local computer. A System DSN is a specific category of Machine DSN that is available to all users and system services on that computer, whereas a User DSN is only visible to the specific Windows user who created it.