Where are the 32bit ACCDB ODBC drivers in Windows 10? Office 2016

Question

I have Windows 10 (64bit) and Office 2016 (32bit).

I launched the 32bit ODBC manager in C:\Windows\SysWOW64\odbcad32.exe but the only thing listed there are the drivers for MDB files, not ACCDB files.

Why would Office 2016 32bit not install these drivers? I did look at the 64bit ODBC manager out of curiousity and as expected, they aren't there either.

How do I connect to an Access ACCDB file via ODBC in Windows 10?

Answer 1

You need to install them. Here's the 2010 Database Engine Redistributable:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

If that doesn't work, you can try the 2007 Data Connectivity Components:

http://www.microsoft.com/download/en/confirmation.aspx?id=23734

I realize these are for earlier versions of what you're running, but they'll generally work with no issue.

Answer 2

Ok. Any clue why Office 2016 doesn't include these? Is MS doing away with ODBC?

This is also an issue for Excel 2016.

Do you have a link to any downloads to update the library and driver references.

Use the same 2010 file above. I've been using it just fine. I have ot "repair" it every few weeks because something in Office 2016 steps on it and breaks it in the ODBC manager, but that takes about 10 seconds then it works for a few more weeks.

Answer 3

Ok. Any clue why Office 2016 doesn't include these? Is MS doing away with ODBC?

This is also an issue for Excel 2016.

Do you have a link to any downloads to update the library and driver references.

Answer 4

Ok. Any clue why Office 2016 doesn't include these? Is MS doing away with ODBC?