Database Toolbox: Talking to MS Access using JDBC

Hi, I am attempting to use Sun's JDBC-ODBC bridge to connect to Microsoft Access using the Database Toolbox.

Configuration: Microsoft Access 2010 (32-bit), MATLAB R2010b (32-bit), running on Windows 7 Enterprise (64-bit).

The command I tried is:

   conn = database('MS Access Database', '', '', ...
   'sun.jdbc.odbc.JdbcOdbcDriver', ...
   'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=<PATH TO ACCDB FILE>');

The message I get in conn.Message is

"[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'."

Is there a way to connect to a Microsoft Access ACCDB file using JDBC, without having to set up the data source in advance, if the path to the ACCDB file is available?

Thanks.

[sst]

Point to note: The problem seems to exist with both MDB and ACCDB files.

Answer 1

[Andreas Pomp]

We had the same problem. We could resolve it by replacing the 64 bit Matlab version by a 32 bit version. The connection to Microsoft Access runs smoothly with the 32 bit Matlab version. No additional installations od drivers were needed on our side.

Regards Andreas