MATLAB: Database Toolbox: Talking to MS Access using JDBC

Database Toolboxmicrosoft access

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.

Best Answer

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
Related Question