Query is corrupt fix not working

mlcktmguy
mlcktmguy used Ask the Experts™
on
I am aware of the "Query is corrupt" issues caused by the MS November update.  I am a developer and sent the notice and link to the fix to all of my clients when the issue occurred.

I hadn't encountered the issue with anything I was running or developing on my office machines so I too no action.

My office machines are 64 bit Win 7 Pro, Office 2013 Pro 32-bit.

Now I'm trying to test something on my office machine and encountered the "query is corrupt" message.

I went back to the MS link with instructions to resolve the issue, downloaded the fix for my environment (ace2013-kb2965317-fullfile-x86-glb.exe).  However, when I run the fix I get a message "There are no products affected by this package installed on this machine".  

I'm obviously missing something but cant' figure pout what it is.

Can anyone suggest what might be happening?

The top of this pic is snapshot from my Office application, the bottom of the pic is the snapshot from the MS 'fix' website.  I clicked on the option to download the fix to the 32-bit version of office which resulted in 'ace2013-kb2965317-fullfile-x86-glb.exe' being downloaded.  

Query Is Corrupt Fix Not Working
Attempt to install the downloaded file led to the message telling me the fix didn't apply to anything on my machine.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You are using CTR version of office, therefore the MSI based patch does not apply.

According to this source the release is scheduled for December 10:
https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

Supposedly you can roll back your CTR to a previous version by following these instructions:
You have to use the
officec2rclient.exe command to revert your installation to a prior build
(before this whole issue surfaced). So open a command prompt, swicth
into the officec2rclient.exe directory and run the command. Something
like:

cd C:\Program Files\Common Files\Microsoft Shared\ClickToRun

officec2rclient.exe /update user updatetoversion=15.0.5179.1000

And then remember to disable updates.
Joshua KinselComputer Programmer

Commented:
Update again.  This has been fixed as of Monday.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
The C2R version of Access 2013 will not have a fix until December 10th, so you have 3 choices:
Thanks Anders.  There were only a few queries that were causing an issue so I followed the information in the link that you sent to make them work. Crisis averted.

If you encounter this issue before the fix is available, the recommended workaround is to update the query so that it updates the results of another query, rather than updating a table directly.

For example, if you have a query similar to:

UPDATE Table1 SET Table1.Field1 = "x" WHERE ([Table1].[Field2]=1);

You can create a new query (Query1) defined as:

SELECT * from Table1;

And update your original query to:

UPDATE Query1 SET Query1.Field1 = "x" WHERE ([Query1].[Field2]=1);

By replacing all references to Table1 with Query1

This will produce the same results, but avoid the error.

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