An Engineers Notebook

Microsoft Access Query is Corrupt Error 3340

The best way to fix the problem is to uninstall the Security Update for Office which is the source of the problem. The solution is different based on whether your Access installation is from a traditional perpetual license, ACE, or Office 365 subscription.

Perpetual License and Disk Installations of Office/Access, and ACE Distribution Installations

If you installed Access/Office directly on your machine through a perpetual license, local setup program/disk, or distributed the Access Database Engine (ACE), the Security Updates were installed on the machine outside of the Office 365 subscription service. Follow the steps below to find and uninstall the updates:

  1. Press the Windows key and R to bring up the Run prompt.
  2. Type “appwiz.cpl” and press [OK] to launch the Control Panel’s Program and Features program.
    Run command
  3. Click [Viewed installed updates].
    View installed updates
  4. In the Search bar, search for the following KB’s.
    • Office 2010: KB4484127
    • Office 2013: KB4484119
    • Office 2016: KB4484113

  5. On this system, KB4484127 is present.
  6. Right-click the program, and select [Uninstall].
  7. Click [Yes] to start the uninstall process.
  8. The prompt will ask if you’re ready to uninstall. Click the [Uninstall] button to proceed.
  9. Click [OK] when the uninstall of the update was successful.

In our experience, if this uninstalls all the offending security updates, the problem is resolved without a need to reboot.

We will have additional information for Office 365 installations shortly.

Microsoft Office 365Office 365 Subscription (Click to Run) Installations

For Office 365 Users, follow these steps:

  1. Open Office and under “Account” choose the option to disable updates.
  2. Use this link to look up the version of Office that you want to revert to: Update history for Office 365 ProPlus (listed by date)
    For instance, “16.0.12130.20272”
  3. Download the Office Deployment tool (Download)
    Follow the prompts to unzip the files to a folder that’s easily accessible.
  4. In that folder, use Notepad to create a new file named “config.xml” containing:
    <Updates Enabled="TRUE" TargetVersion="16.0.12130.20272" />
  5. In an elevated command prompt, change directories to the folder where you unzipped the files. Then run the following command:
    setup.exe /configure config.xml
  6. Open an Office program and go to the Account page, and “get updates now”.  This reverts back to update 16.0.12130.20272.

Microsoft resource: How to revert to an earlier version of Office 2016 Click-to-Run

Leave a Reply

Your email address will not be published.