Urgent Help Need Uninstalling MS Office/Access 2013 Patch Update (KB4484119)

horatio_too
horatio_too used Ask the Experts™
on
Hi

We have a wall-to-wall business system, built over 12 years in Access 2013, which has been crippled by  the 'Corrupt Query' bug in KB4484119, released in November 2019 (See

https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

).

This Access-based system is not just business-critical, it effectively IS the business, so we desperately need a solution ASAP.

Microsoft's proposed workaround of rewriting our queries is, frankly, absurd - we have hundreds of queries, plus a similar number embedded in VBA code, so the scale of the task is simply prohibitive.

As such, until "a patch for the patch"/Hotfix is released, we need to uninstall the KB4484119 patch - but I can't see how to do this !

To be clear, NO MS Office 2013 patches are being shown in

Control Panel, Programs and Features, View Installed Updates

whilst the Update Options button in Access 2013 itself will allow many things, but NOT to reverse off an update already installed...

We are running Windows 10 Pro and MS Office 2013 in 32-bit, preinstalled (if memory serves me correctly) by Dell on our Optiplex 7010's - so I am sort of assuming an MSI installation ?

Access reports its current version as 15.0.5189.1000.

As such, any help or guidance that anybody is able to give will be gratefully received.

Many thanks in advance

Horatio_too
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013

Commented:
Microsoft is rolling out Hotfixes now
https://borncity.com/win/2019/11/19/fix-for-error-3340-in-access-2016-update-kb4484198/
The 2016 fix is already available, the 2013 was due yesterday, just checking on status now but despite the frustration for the sake of a few days would advise holding off on other ways of doing it as there is currently no supported means of downgrading.  However there are some unsupported uninstall methods suggested in the link above.

Update:
Patch out "Early next week" and will be linked to on the M$ page in the body of your question.

Author

Commented:
Hi Masq

Many thanks for your quick response. Whilst the 2013 Hotfix WAS scheduled for Friday 22nd November, the official MS page that I linked to in my original question has now been updated to 29th November !

To reiterate, without our system, we have No business, so waiting a week (or more...) is not an option for us.

Kind regards

Horatio_too
Most Valuable Expert 2013

Commented:
See the Technet links off the page I've already posted for interim workarounds to the installation rather than modifying queries.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Hi Masq

I am possibly just being dense, but I cannot immediately see any of the links which apply to Office 2013 via an MSI installation ?

Lots of 2016 and Click-to-Run suggestions but unless I have missed something, nothing that matches our own configuration.

Thanks anyway

Horatio_too
Most Valuable Expert 2013
Commented:

Author

Commented:
Hi MASQ

Many thanks for staying with me.

I worked my way through a bunch of the suggestions from that Stackoverflow page yesterday, without any success.

However, I will retry any number of them today, just in case a clearer head and a fresh pair of eyes makes any difference.

So far, the following batch file did NOT work for me (update queries still fail and Access 2013 still reports 15.0.5189.1000, even after a reboot) :-


reg query HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{90140000-001C-0000-0000-0000000FF1CE}
if %errorlevel% equ 0 (
  "C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\Oarpmany.exe" /removereleaseinpatch "{90140000-001C-0000-0000-0000000FF1CE}" "{F11D3275-8FE0-4ADB-B737-9766F9D0AD5B}" "1031" "0"
)

REM KB4484119 (Office 2013)
reg query HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{90150000-006E-0407-0000-0000000FF1CE}
if %errorlevel% equ 0 (
  "C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\Oarpmany.exe" /removereleaseinpatch "{90150000-006E-0407-0000-0000000FF1CE}" "{3B7EE494-CBED-477C-AF90-8B8653C86985}" "1031" "0"
)

REM KB4484119 (Access 2013 Runtime)
reg query HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{90150000-001C-0000-0000-0000000FF1CE}
if %errorlevel% equ 0 (
  "C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\Oarpmany.exe" /removereleaseinpatch "{90150000-001C-0000-0000-0000000FF1CE}" "{3B7EE494-CBED-477C-AF90-8B8653C86985}" "1031" "0"
)

Kind regards

Horatio_too

Author

Commented:
Hi

I have now also tried using the PowerShell script found here:-

https://www.arcath.net/2017/09/office-update-remover

Unfortunately, again without any luck (and a manual registry search for the offending KB - 4484119  - yielded no luck either...

For completeness, the PowerShell script linked to above is:-

#############################################################
#
# Office Update Remover
#
# By Adam Laycock (arcath.net)
# September 2017
#
#############################################################
Param(
    [Parameter(Mandatory=$True,Position=1)][string]$kb
)

$officePID = $False
$updatePID = $False

Get-ChildItem HKLM:\Software\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall -rec -ea SilentlyContinue | foreach {
    $currentKey = Get-ItemProperty -Path $_.PsPath
    if($currentKey.DisplayName -like "*" + $kb + "*"){
        $parts = $currentKey.PSChildName.Split("_")
        $officePID = $parts[0]
        $updatePID = $parts[2]
    }
}

# If the patch was not in 64bit registry look in 32 bit
if($officePID -eq $False -and $updatePID -eq $False){
    Get-ChildItem HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall -rec -ea SilentlyContinue | foreach {
        $currentKey = Get-ItemProperty -Path $_.PsPath
        if($currentKey.DisplayName -like "*" + $kb + "*"){
            $parts = $currentKey.PSChildName.Split("_")
            $officePID = $parts[0]
            $updatePID = $parts[2]
        }
    }
}

if($officePID -ne $False -and $updatePID -ne $False){
    $args = @(
        "/package"
        $officePID
        "/uninstall"
        $updatePID
        "/qn"
        "/quiet"
        "/norestart"
    )

    Write-Host "msiexec" $args

    Start-Process "msiexec.exe" -ArgumentList $args -Wait -NoNewWindow
}

Kind regards

Horatio_too

Author

Commented:
Hi

After MUCH battling, it finally transpired that (despite NOT obviously saying it within Access 2013) our version pre-installed by Dell was "Click To Run".



As such, the Stackoverflow link provided by MASQ, revisited today, DID help:-

https://stackoverflow.com/questions/58832269/getting-error-3340-query-is-corrupt-while-executing-queries-docmd-runsql/58833831#58833831

albeit with a slight tweak.

  1.    Turn off Updates within Access 2013 via File, Account, Office Updates (you need a database open for this option to be available)
  2.    Run Powershell as Admin
  3.    cd "C:\program files\Microsoft Office 15\clientx64"
  4.    ./officec2rclient.exe /update user updatetoversion=15.0.5179.1000

The dot in bullet 4 before /officec2rclient.exe was the crux for me - without it, PowerShell was failing.

Kudos to MASQ for getting me to revisit the Stackoverflow article. Now  Microsoft need to get that Hotfix issued !

Horatio_too

Author

Commented:
Hi MASQ

Thanks once again for getting me to revisit the Stackoverflow page and for reaching out to me in my hour(s) of need.

Horatio_too
Most Valuable Expert 2013

Commented:
Hey thanks :)
I think you still did most of the work though.
Pressure off for your business, and you too.
Enjoy the rest of the weekend!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial