The November 12, 2019 Microsoft Office updates introduced a bug in MS Access where users are seeing errors like this “Query is corrupt”. Microsoft has acknowledged the bug and says a fix will be out with the updates on December 10. See link here from Microsoft for more information:
To fix the issues in the meantime, you can uninstall the application Office Update for Access 2010, 2013 or 2016 as follows:
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)
To uninstall the update in Windows Server 2016, go to Settings, Windows Update, Update History, click hyperlink toward top of page for Uninstall Updates, search for KB noted above, uninstall. Even though it doesn’t require a reboot, we recommend you reboot your server after the uninstall.
Next you will want to disable automatic Windows Updates so the same buggy update does not get automatically installed again. If you are a Riptide Hosting client, contact us to disable automatic updates which varies depending on which Windows Server OS you are on. If you disable automatic updates temporarily (under MS releases the fix by December 10 according to the link above), you need to remember to enable them to keep your system secure and up-to-date. If you are a Riptide Hosting client, please contact us before disabling automatic updates.