Microsoft Access Driver (*.mdb, *.accdb) system error code 126.

When I try to set up a DSN to an access 2003 database (or 2007) on my 64-bit Windows 7 PC, I get the following error:

The setup routines for the Microsoft Access Driver (*.mdb, *.accdb)
ODBC driver could not be loaded due to system error code 126: The
specified module could not be found.
(c:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEODBC.DLL).

The files it is looking for are in "Program Files (x86)" instead of "Program Files" where it is looking, but copying them to the expected path does not fix the issue.

Any help would be greatly appreciated.

 

Question Info


Last updated September 25, 2018 Views 43,301 Applies to:
Answer

You need to go to

 

C:\Windows\SysWOW64\obdcad32.exe

 

that will load the 32 bit odbc manager which is needed for creating DSN's with 32 bit drivers.

 

Also, just a note, in case it is necessary - If using Access and you want to connect to another Access database you can't use an ODBC connection.

-----
Microsoft Access MVP 2008, 2009, 2011
If a post was helpful click the FOUND THIS HELPFUL link

27 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.