Query is corrupt fix not working
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-fullfil
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-fullfil
Attempt to install the downloaded file led to the message telling me the fix didn't apply to anything on my machine.
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-fullfil
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-fullfil
Attempt to install the downloaded file led to the message telling me the fix didn't apply to anything on my machine.
Do more with
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.
And then remember to disable updates.
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.
And then remember to disable updates.
The C2R version of Access 2013 will not have a fix until December 10th, so you have 3 choices:
- Wait
- Uninstall the flawed updates (Anders explains how in his post above)
- Run a fix such as CurruptQueryAccessWorkarou
nd: Query ” is corrupt (which is reversible once Microsoft issues an official fix)
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial