As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcactRelated and similar functions. Further, it offers better read-out of Multi-Value fields.
Microsoft Access Query is Corrupt errors.
Earlier this week, Microsoft released several Security Updates that caused update queries in Microsoft Access database applications and programs storing data in Microsoft Access databases to fail.
An erroneous Query is Corrupt message appears.
Microsoft Access 2010, 2013, 2016, 2019 and Office 365
32 and 64 bit versions of Access
Applications that use the Access Database Engine (ACE) such as those written in Visual Studio .NET, VB6, and even web solutions that update Access databases.
Detailed Article with Multiple Workaround Suggestions
Our customers encountered this confusing error, and our team investigated and published an article to explain the issue and how to mitigate it. Microsoft announced they will fixed this in the next security update in December. That's hardly acceptable for applications that were running perfectly fine on Monday. Hope this helps.
It appears that a security update for the CVE-2019-1402 vulnerability in each version of Microsoft Office causes this error. Here is the list of Office security updates that you can uninstall.
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)