FIX: Run-time Error ‘3340’: Query ” is Corrupt

Introduction

Microsoft recently rolled out a Microsoft Office update that that prevents 3rd party Microsoft Access applications from using update queries.  This patch will break all supported versions of Access.  Any one who has automatic Office Updates enabled will have received this error when attempting to launch Stone Edge.

The fix is to disable automatic updates for Microsoft Office and then uninstall or rollback the update from 11/13/2019.  Continue reading for instructions on how to do this.

Microsoft has already fixed the update with but will not publish the update until December 10th for most versions of Office.  For more information on Microsofts release schedule click here:
https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

Turn off Microsoft Office Automatic Updates

To stop getting updates and features for Office on Windows 10, use these steps:

1. Open an Office app, such as Word.
2. Create a new blank document.
3. Click on File.
4. Click on Account.
5. On the right side, click the Update options menu.
6. Select the Disable Updates option.
7. Click the Yes button to confirm.

Once you complete these steps, your Office apps will no longer download and install updates automatically.

Microsoft Access Update Rollback for Access 2010/2013/2016

1. Open Control Panel.
2. Under Programs, click on “Uninstall a program”
   
3. Choose the “View installed updates”
   
4. Do a search for:

• • Using Access 2010 “KB4484127”
  • Using Access 2013 “KB4484119”
  • Using Access 2016 “KB4484113”

(if this file is not found, proceed to the Office 365 instructions towards the bottom of this document)

5. Highlight the update and the “Uninstall” link will appear.
   
6. After the uninstall is complete, restart the workstation and then reopen Stone Edge.

Instructions for Office 365

1. First open Access directly and go to Account.
2. Then go to Office Updates and then to Disable Updates.
3. Go to the Windows Start Menu and begin typing “Command Prompt” without the quotes.
4. Once it shows up in the list to select, right click on it and selected Run as Admin.
5. Type or copy & paste:
   cd %programfiles%\common files\microsoft shared\clicktorun
   Press Enter
6. Then type or copy & paste:
   officec2rclient.exe /update user updatetoversion=16.0.12130.20272
   Press Enter
7. Open up Stone Edge.