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

1 view (last 30 days)
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

Answers (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

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!