[Solved] Java database connectivity exception

Question

{Microsoft Access Driver (*.mdb)} is the name of the older Microsoft Jet driver, which will only work in 32-bit applications. (There are no 64-bit versions of the Jet database engine or the Jet ODBC driver.)

To connect with .mdb and .accdb files from a 64-bit application you need to download and install the 64-bit version of the Access Database Engine (a.k.a. “ACE”) from here, and then refer to it in your application by using the driver name {Microsoft Access Driver (*.mdb, *.accdb)}.

Accepted Answer

{Microsoft Access Driver (*.mdb)} is the name of the older Microsoft Jet driver, which will only work in 32-bit applications. (There are no 64-bit versions of the Jet database engine or the Jet ODBC driver.)

To connect with .mdb and .accdb files from a 64-bit application you need to download and install the 64-bit version of the Access Database Engine (a.k.a. “ACE”) from here, and then refer to it in your application by using the driver name {Microsoft Access Driver (*.mdb, *.accdb)}.