Microsoft Access Database Engine 2019 Redistributable: Uninstalling the Problematic Security Update

Are you experiencing issues with your Microsoft Access database due to a recent security update? If so, you're not alone. Many users have reported errors and failures when trying to update data in their Access databases after installing the latest security patch. In this article, we'll walk you through the steps to uninstall the problematic security update and get your Access database up and running again.

The problem is caused by a security update that was pushed out by Microsoft as part of their November 'Patch Tuesday'. The update affects all versions of Access, including 2010, 2013, 2016, 2019, and 365 ProPlus. The error message you're likely seeing is HY000 (-3067): Query '' is corrupt, indicating that the query is invalid.

To uninstall the problematic security update, follow these steps:

1. Open Control Panel and navigate to Programs => Programs and Features => Installed Updates.

2. Sort the list by 'Installed On' and scroll to the groups starting with 'Microsoft Office'.

3. Uninstall the security update that corresponds to the version of Access you're using.

If you're still experiencing errors after uninstalling the update, you may need to install a specific hotfix depending on your version of Access. For example, if you're using the Access Database Engine 2010 Redistributable, you'll need to install KB2986256.

It's worth noting that this problem is not caused by any changes or bugs in your EDS (Enterprise Data Services) application, but rather by a mistake on Microsoft's part. Customers who use SQL Server databases instead of Access should not be affected by this issue.

Microsoft has since rolled out fixes for all versions of Office, including the Access Database Engine 2010 Redistributable and the Access Database Engine 2016 Redistributable. These updates can be delivered via Windows Update/Microsoft Update or can be downloaded manually from the MS Knowledge Base pages linked above.

In conclusion, uninstalling the problematic security update is the only way to get your Microsoft Access database functioning properly again until a fix is available for your version. By following these steps, you should be able to resolve the issue and continue using your Access database without any problems.

Microsoft access database engine 2019 redistributable