When attempting to run an Update query, it may not run and displays the error: "Query 'query name' is corrupt".
This will occur for an Update query that:
Updates a single table (i.e. it updates a table, rather than the output of a Select query, or join
Specifies a WHERE clause (i.e. has entries in the Criteria row in the query designer)
This issue impacts all supported builds of Access.
The issue was introduced on November 12, 2019 via the following patch updates for MSI builds:
Office 2010: Description of the security update for Office 2010: November 12, 2019 (KB4484127)
Office 2013: Description of the security update for Office 2013: November 12, 2019 (KB4484119)
Office 2016: Description of the security update for Office 2016: November 12, 2019 (KB4484113)
Office 2016: November 12, 2019, update for Office 2016 (KB3085368)
The table below lists the dates/build numbers for the earliest available update, but for MSI builds, the patch referred to is not a required patch and must be manually applied. There is a December 10 security update for the MSI builds, that will be available via WSUS and will be automatically applied that fixes the issue:
2010: KB4484193 – build 14.0.7243.5000
2013: KB4484186 – build 15.0.5197.1000
2016: KB4484180 – build 16.0.4939.1000
When you want to retrieve data from a database, you ask for the data by using Structured Query Language, or SQL. SQL is a computer language that closely resembles English, but that database programs understand. Every query that you run uses SQL behind the scenes.
Understanding how SQL works can help you create better queries, and can make it easier for you to understand how to fix a query that is not returning the results that you want.
This is one of a set of articles about Access SQL. This article describes the basic use of SQL to select data, and uses examples to illustrate SQL syntax.