Question

Q: Microsoft Access Driver (*.mdb, *.accdb) system error code 126. This thread is locked from future replies

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.

Answer

A:

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

Did this solve your problem?

Sorry this didn't help.

23 people were helped by this reply



 
Question Info

Views: 41,367 Last updated: April 19, 2018 Applies to: