MATLAB® crashes when using a Microsoft® Access™ ODBC driver

When you use the Microsoft® Access™ ODBC driver, MATLAB sometimes experiences unexpected behavior. The stack trace from a crash might be:

[ 0] 0x00007ff94f826de4 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01076708

[ 1] 0x00007ff94f826ee3 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01076963

[ 2] 0x00007ff94f825e8b C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01072779

[ 3] 0x00007ff94f8260b4 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01073332

[ 4] 0x00007ff94f82e3e8 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01106920

[ 5] 0x00007ff94f7ef30d C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+00848653

[ 6] 0x00007ff94f7f5b25 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+00875301

[ 7] 0x00007ff94f80818f C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+00950671

[ 8] 0x00007ff94f7c24b5 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+00664757

[ 9] 0x00007ff94f883180 C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACECORE.DLL+01454464

Answer 1

[MathWorks Computational Finance Team]

To avoid the unexpected behavior, you can use either of these workarounds:

• Upgrade to the Access 2016 ODBC driver.
• Create a MATLAB function to open the Access database connection, execute an SQL query, and close the connection; for example:

            function out = myQueryExecute(sqlquery)
            conn = database(datasource,username,password);
            out = select(conn,sqlquery);
            close(conn)
            end