ODBC drivers not found

Question

I would like to open a 2007 Access database in R. To do so I am using the following code:

RIFSdatabase <- odbcConnectAccess2007(paste(db.dir, DB.filename, sep='/'))

If ran in 32 bit R (R console or R studio) the following error is returned:

Warning messages: 1: In odbcDriverConnect(con, ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

2: In odbcDriverConnect(con, ...) : ODBC connection failed

If ran in 64 bit R (R console or Rstudio) the following error is returned:

Warning messages: 1: In odbcDriverConnect(con, ...) : [RODBC] ERROR: state IM003, code 160, message Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Access Driver (*.mdb, *.accdb), C:\Program Files\Common Files\Microsoft Shared\OFFICE16\ACEODBC.DLL). 2: In odbcDriverConnect(con, ...) : ODBC connection failed

MS Access Database drivers (*.mdb, *accdb) are listed as User DSN but...if I click configure I get the error message:

"The setup routines for the Microsoft Access Driver (*mdb, *accdb) ODBC driver could not be loaded to system error code 126: The specified module could not be found. (C:\Program Files\Common Files\Microsoft Shared\OFFICE16\ACEODBC.DLL)

How can I fix this connection error?

I have not used my ODBC drivers on this computer for anything else - based on these errors are they perhaps not installed (despite being listed as User DSN)?

I do not care if I run R in 32 or 64 bit.

Answer 1

Performing a google search with your error code showed the follow answer to a post with the same error on Microsoft:

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.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/microsoft-access-driver-mdb-accdb-system-error/def76bd8-ffc6-44ec-a3e4-47a839b1314e