Access error: 'Query is corrupt'

[vbprgmr]

On Nov 11, Microsoft pushed out a security update for all versions of MS Access and inadvertently introduced a SERIOUS bug which could affect all current users of Access.
This bug 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.

MS is saying the fix will be available on Dec. 10.

Link:

https://support.microsoft.com/en-us/help/4484127/security-update-for-office-2010-november-12-2019

Look at the link for a workaround.

Oh Happy Days!
vbprgmr

 

[dhookom]

Thanks for posting this. It might head off questions here (as long as the forum is searched first).

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[dhookom]

This just off the presses from the Microsoft Access team:

We are getting patches out, this is the first available, for Office 2016 MSI installations:

https://support.microsoft.com/en-us/help/4484198/november-18-2019-update-for-office-2016-kb4484198

Just to be clear, this won’t help Office 2010 or 2013, for which patches will be following shortly.

For O365 Monthly Channel, or Office 2016 C2R installs, an update will be also be available very soon.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[DjangMan]

FMS made a nice post about the issue:

https://www.fmsinc.com/MicrosoftAccess/Errors/query_is_corrupt/index.htm