The error "Query'' is corrupt" shows when trying to update MS Access database
Article ID: 311 - Updated: Nov 25, 2019 - Version: V2019, V2017 - Category: Connectivity and Database
When you try to run the update query agains Microsoft Access database, the following error message is shown.
Data update failed.
System error message:
Query '' is corrupt.
You might experience the problem while editing data in Table object in PowerForms application, or when executing custom "Execute SQL statement" action.
Windows Update introduced an issue in MS Access provider where update queries fail with the error "Query '' is corrupt".
All NiceLabel 2019 and 2017 versions are affected.
Issue was identified as error on November 15th and will be fixed by Microsoft. The fix is scheduled for December 10th. In the meantime, the workaround is uninstalling KB that introduced the issue. See more info below for details provided from Microsoft.