Since upgrading from MATLAB 2016a (64-bit) to MATLAB 2017a (64-bit) on Windows 2008 R2 server, updating records in an Access 2016 database no longer works. I connect to the Access database, an ODBC system file, using database(). I can run the same scripts in the 2016a environment and the update is successful. When I compare the update.m scripts that are called by MATLAB, they are very different ([path] is simply the system disk and directory):
2016a: [path]\Program Files\MATLAB\R2016a\toolbox\database\database\@database\update.m2017a: [path]\Program Files\MATLAB\R2017a\toolbox\database\database\+database\+odbc\@connection\update.m
The error message is:
message: 'ODBC Driver Error: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect 'stack.file: '[path]\Program Files\MATLAB\R2017a\toolbox\database\database\+database\+odbc\@connection\update.m'stack.line: 301
I've searched other boards on this ODBC error and tried some advice found there (i.e., verifying a field name isn't an SQL Keyword).
I am able to insert new records (fastinsert, datainsert), but can NOT update records.
Best Answer