MS Access Error Query is Corrupt from November 12, 2019 Office Updates

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. 

Deploy your MS Access Database, MS Access Application online to the cloud with Remote Desktop Services (terminal services)

The quickest and easiest method to move your Microsoft Access Database online (to the cloud) is to deploy it on a hosted Windows Remote Desktop Server.  You should be able to move to a Window Remote Desktop server with MS Access and be up and running on the same day!  We have been providing terminal server (remote desktop) hosting solutions for over 15 years.  Contact us and to discuss your options, pricing, MS licensing, etc.   We host your Access database on its own server (not shared OS, not sharepoint) with resources dedicated to you.  You will have a better experience hosting your MS Access database with us than other providers using a shared OS environment.

As previously announced by Microsoft, Access-based web apps (Access Web Apps) and Access web databases in Office 365 and Sharepoint Online were shut down in April 2018.  See link here:  Access Services in Sharepoint shut-down

You can also review our pricing calculator here:

When comparing options for hosting your Access application online, ask the hosting provider if it will be a Windows Server with Remote Desktop Services or if they are hosting the Access application on a Sharepoint server.  We do not provide hosting services on Sharepoint.  If your MS Access application has VBA coding, it may not work in a sharepoint environment.  You should also ask if your application is hosted in a dedicated OS environment (dedicated VM for you), or if it is on a shared OS environment, or if running on Sharepoint.

MS Access Services retired in Office 365 and Sharepoint Online – Look at MS Access Hosting with Riptide Hosting


Microsoft announced that  Access-based web apps and Access web databases in Office 365 and SharePoint Online will be shut down by April, 2018.  See link here:

This does not affect Access Desktop databases (.accdb).

One alternative you should consider is use of a Windows Remote Desktop Server with Access or Access runtime installed.  Riptide Hosting has been providing terminal server (remote desktop) hosting solutions for over 15 years.  Contact us to discuss pricing and options. 

See Access DB Hosting pricing offered by Riptide Hosting, Inc.:

Access Runtime (free download) on our Remote Desktop (Terminal) Servers

Do you need full MS Access to create/modify Access databases or do you only need Access runtime to allow users to only run existing Access databases.  If you only need Access Runtime, you can save on Office licensing fees.

Riptide Hosting can provide Microsoft licensing for the full version of Access 2019, Access 2016, Access 2013) / Office Professional which is best if you need the full features of Access including creating and editing the database tables and forms– see our pricing calculators for current pricing.

Microsoft also offers MS Access Runtime as a FREE download which may be an option depending on your situation, for example if you have already created a database application which has forms to input and manipulate the data. Runtime is limited to running an already existing/created Access application. An access developer who develops an access application can install the application on computers and servers using the free Microsoft Access runtime rather than licensing Access for each computer.

Links to download Microsoft Access Runtime (Redistributable) are below:

Microsoft Access 2016 Runtime download from Microsoft

Microsoft Access 2013 Runtime download from Microsoft:

Office 365 Runtime for Access 2019 download from Microsoft (note: cannot co-exist with regular Office 2016/2019 so only use if no other Office project is installed)

The description of Runtime from the Microsoft Download Center for 2016 Runtime is copied in here:

“The Microsoft Access 2016 Runtime enables you to distribute Access 2016 applications to users who do not have the full version of Access 2016 installed on their computers.”

“Microsoft Access 2016 provides a rich platform for developing database management solutions with easy-to-use customization tools. If no end-user customization is required (including report modifications), you can choose to distribute those Access 2016 solutions so that they run without requiring a full installation of Access 2016. To do so, you must package and distribute your application with the Access 2016 Runtime.

The Access 2016 Runtime is similar to previous runtimes in that all design-related UI is either removed or disabled.

You do not need to buy any special product in order to redistribute the Access 2016 Runtime. You can freely redistribute it or point users to this download. “

Below is a link for “Access for developers” from Microsoft’s MSDN site as additional reference:

Remote Desktop sessions varying speed opening database reports

Windows Server 2008R2 with remote desktop services role (terminal services) and Access database

We recently had a user notice that database reports would open up at different speeds in different remote desktop sessions. After trying many different things, it was determined that printer redirection was causing some sessions to open database reports more slowly than others and the reports would open much faster if printer redirection was unchecked under local resources when making the remote desktop connection.