Skip to content
Tech Shizz Logo

An Engineers Blog

  • TechShizz
  • blog

Microsoft Access Query is Corrupt Error 3340

Posted on February 23, 2021 By rich No Comments on Microsoft Access Query is Corrupt Error 3340

Immediate Solution: Uninstall the Security Updates

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:
    <Configuration>
    <Updates Enabled="TRUE" TargetVersion="16.0.12130.20272" />
    </Configuration>			
    
  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

Post navigation

Next Post: List all SMTP Addresses for all Mailboxes or Distribution Groups in Exchange ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to our newsletter!

Recent Posts

  • How to implement a lightning-fast ransomware playbook
  • How to achieve defence in depth in your business
  • How to implement a SecOps team phishing response plan
  • How to block an Office 365 Sign-in correctly
  • Microsoft finally patched serious Exchange 0-day over a month old!

Recent Comments

    Archives

    • November 2022
    • July 2021
    • March 2021
    • February 2021

    Categories

    • Cyber Security
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2023 .

    Theme: Oceanly News Dark by ScriptsTown