Knowledge Base

The error "Query'' is corrupt" shows when trying to update MS Access database

Problem

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.

Solution

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.

More info:
https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

Print document   Email document

Feedback

Did this article help you? *