sodcalculator

10 Tech How-To

Install Microsoft Access ODBC Driver: Step-by-Step

Guide 10-33981 · Updated · Step by step

This guide walks you through installing the Microsoft Access ODBC driver, which lets your applications connect to Access databases (.mdb and .accdb files) using standard ODBC interfaces. You’ll learn how to download the correct driver, run the installer, and verify the installation. Before you begin, ensure you have administrator rights on your Windows computer and know whether your applications are 32-bit or 64-bit, as this determines which driver version you need.

What You’ll Need

  • A Windows PC (Windows 10 or 11 recommended)
  • Administrator account access
  • Internet connection to download the driver
  • Knowledge of whether your target application is 32-bit or 64-bit (most modern apps are 64-bit, but some legacy ones are 32-bit)

Step-by-Step

  1. Determine the correct driver version. If your application is 64-bit, download the 64-bit driver. If it’s 32-bit, download the 32-bit driver. If you’re unsure, check the application’s documentation or Task Manager (look for “(32-bit)” next to the process name).
  2. Go to the official Microsoft Download Center. Open your browser and navigate to microsoft.com/download. Search for “Microsoft Access Database Engine” or “Access ODBC Driver.” The current versions are 2016 and 2010, both work on modern Windows.
  3. Choose the right download file. On the download page, you’ll see options like AccessDatabaseEngine.exe (for 64-bit) and AccessDatabaseEngine_X64.exe (also 64-bit) or AccessDatabaseEngine_X86.exe (for 32-bit). Select the one matching your application’s architecture.
  4. Run the installer. Double-click the downloaded file. If a User Account Control prompt appears, click “Yes” to allow the installer to make changes.
  5. Accept the license terms. Read the Microsoft Software License Terms, check the box to accept, and click “Next.”
  6. Choose installation type. The installer may offer two options: “Click-to-Run” (default) or “Custom.” For a standard ODBC driver install, select the default. If you need to install both 32-bit and 64-bit versions, you’ll have to run the installer twice, but note that the 32-bit installer cannot be run if a 64-bit Office is already installed, and vice versa.
  7. Complete the installation. Click “Finish” when done. The driver is now installed.
  8. Verify the installation. Open the ODBC Data Source Administrator: press Win + R, type odbcad32.exe (for 64-bit) or odbcad32.exe from SysWOW64 (for 32-bit), and press Enter. Go to the “Drivers” tab and look for “Microsoft Access Driver (*.mdb, *.accdb)” or similar. If it’s listed, the driver is ready to use.

Common Mistakes

  • Installing the wrong bitness. This is the most frequent error. A 32-bit application cannot use a 64-bit ODBC driver and vice versa. Always match the architecture.
  • Running the installer without admin rights. The installer will fail or not install correctly if you don’t have administrator privileges. Right-click the installer and select “Run as administrator” if needed.
  • Conflicting Office installations. If you have a 32-bit version of Microsoft Office, you cannot install the 64-bit Access Database Engine. You’ll need to install the 32-bit driver instead, or uninstall Office first (not recommended).
  • Using the wrong driver name in connection strings. The driver name is case-sensitive and includes the file extensions. Use “Microsoft Access Driver (*.mdb, *.accdb)” exactly.

Tips

  • If you’re developing an application, test with both .mdb and .accdb files to ensure compatibility.
  • For 64-bit Windows, the 32-bit ODBC administrator is located in C:\Windows\SysWOW64\odbcad32.exe. The 64-bit version is in C:\Windows\System32\odbcad32.exe.
  • If you only need to read Access files, consider using the ACE OLEDB provider as an alternative, but ODBC is more universal.
  • Keep the driver updated by checking Microsoft’s download page periodically.

Troubleshooting

  • Driver not appearing in ODBC Administrator. If you installed the correct bitness but the driver isn’t listed, try restarting the ODBC Administrator or your computer. Also, ensure you’re looking at the right administrator (32-bit vs 64-bit).
  • “The specified DSN contains an architecture mismatch” error. This means your application is trying to use a DSN created for the wrong bitness. Recreate the DSN using the correct ODBC Administrator.
  • Installation fails with error 1935 or similar. This often indicates a problem with the Microsoft Visual C++ Redistributable. Install the latest Visual C++ Redistributable from Microsoft and retry.
  • Cannot install both 32-bit and 64-bit drivers. The Access Database Engine installer blocks having both versions installed side-by-side. If you absolutely need both, you may have to use command-line switches like /quiet and /norestart to force install, but this is unsupported and may cause issues.
  • Connection string errors in your application. Double-check the driver name and the path to your Access file. Use a tool like the ODBC Test utility to test the connection.

Frequently Asked Questions

Q: Can I use the Access ODBC driver on macOS or Linux?

No, the Microsoft Access ODBC driver is only available for Windows. On other operating systems, you’ll need to use third-party ODBC drivers or convert the Access database to a more portable format like SQLite or CSV.

Q: Do I need Microsoft Office installed to use the driver?

No, the Access Database Engine is a standalone component. You don’t need Office, but you must have the appropriate version (32-bit or 64-bit) that matches your application.

Q: What’s the difference between the ACE and Jet drivers?

Jet (Microsoft Access Driver) is the older driver that supports .mdb files only. ACE (Access Database Engine) is the newer driver that supports both .mdb and .accdb files. Always use ACE if possible.

Q: How do I create a DSN for an Access database?

Open the ODBC Data Source Administrator, go to the “User DSN” or “System DSN” tab, click “Add,” select the Access driver, and enter a name, description, and the path to your database file.

Q: Why does my 64-bit application not see the 32-bit driver?

Because the drivers are architecture-specific. A 64-bit application can only use 64-bit ODBC drivers. You must install the 64-bit version of the Access Database Engine.

Q: Can I use the driver to write to Access databases?

Yes, the driver supports both read and write operations, provided the database file is not read-only and you have appropriate permissions.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →