The error "Query'' is corrupt" shows when trying to update MS Access database
Article ID: 311 - Updated: Feb 23, 2021 - Version: V2019, V2017 - Category: Connectivity and Database
When you try to run the update query in the Microsoft Access database, the following error message shows:
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 'query name' is corrupt".
This affects all NiceLabel versions.
The issue was identified as an error on November 12th 2019 and Microsoft already fixed it. See more Microsoft details and the solution here: