Access error -query is corrupt (1 Viewer)

theDBguy

I’m here to help
Staff member
Local time
Today, 06:40
Joined
Oct 29, 2018
Messages
21,357
NO, just being prepared in case I need to react.
I see. All the information we have is listed on the MS KB article. So, if you haven't been hit with the bug yet, then maybe you're okay. However, if you do get hit with it, I am not sure which of the solutions listed there will apply to you. Good luck!
 

isladogs

MVP / VIP
Local time
Today, 13:40
Joined
Jan 14, 2017
Messages
18,186
All the updates that caused issues were for A2010 or later (though some users of A2007 seem to have had issues)
As support for ADP was I believe dropped in A2010, I can't see any reason why you would be affected
 

Minty

AWF VIP
Local time
Today, 13:40
Joined
Jul 26, 2013
Messages
10,354
Re: Access error -queryW is corrupt

Still waiting if you are on 2019 Volume licence or 2013 C2R, can't believe that will be another 2 weeks...
 

Cliff67

Registered User.
Local time
Today, 06:40
Joined
Oct 16, 2018
Messages
175
Re: Access error -queryW is corrupt

Just followed the instructions on MS update page, check what version of access and is it 32 bit or 64 bit, found I'm at version:15.0.5189.1000 which is one of the wonderfully messed up version. I downloaded the correct KB patch (KB2965317 of 32 bit) only to be told "There are no products affected by this package installed on this system" - Hmmmm! how does that happen when I'm running an affected version of MS Access 2013?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:40
Joined
Oct 29, 2018
Messages
21,357
Re: Access error -queryW is corrupt

Just followed the instructions on MS update page, check what version of access and is it 32 bit or 64 bit, found I'm at version:15.0.5189.1000 which is one of the wonderfully messed up version. I downloaded the correct KB patch (KB2965317 of 32 bit) only to be told "There are no products affected by this package installed on this system" - Hmmmm! how does that happen when I'm running an affected version of MS Access 2013?
Hi Cliff. Sounds like you may have a C2R version of Access, in which case, you would have to wait until December 10 for a fix.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:40
Joined
Oct 29, 2018
Messages
21,357
Re: Access error -queryW is corrupt

Still waiting if you are on 2019 Volume licence or 2013 C2R, can't believe that will be another 2 weeks...
Ah, I missed the dates. Minty, you are correct. There are two more versions waiting on a fix. Cheers!
 

Cliff67

Registered User.
Local time
Today, 06:40
Joined
Oct 16, 2018
Messages
175
Re: Access error -queryW is corrupt

:confused: Oh Bugger - the site says the patch is for 10.0.5189.1000 to update to .1002 so you would think if I'm at that version it should be.

I don't think it is Click to Run Ms access and office is installed on my local drive :( how would I check that?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:40
Joined
Oct 29, 2018
Messages
21,357
Re: Access error -queryW is corrupt

:confused: Oh Bugger - the site says the patch is for 10.0.5189.1000 to update to .1002 so you would think if I'm at that version it should be.

I don't think it is Click to Run Ms access and office is installed on my local drive :( how would I check that?
What is your build number? To find out, go to File > Account.
 

Cliff67

Registered User.
Local time
Today, 06:40
Joined
Oct 16, 2018
Messages
175
Re: Access error -queryW is corrupt

It says Microsoft Access 2013 (15.0.5189.10000 MSO (15.0.5179.1000) 32 bit Part of Microsoft Office Professional 2013

I have the product ID if that helps too
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:40
Joined
Oct 29, 2018
Messages
21,357
Re: Access error -queryW is corrupt

It says Microsoft Access 2013 (15.0.5189.10000 MSO (15.0.5179.1000) 32 bit Part of Microsoft Office Professional 2013

I have the product ID if that helps too
Hi Cliff. My guess is, if you see two buttons: Update Options and About Access, then you have C2R. How many buttons do you see?
 

Cliff67

Registered User.
Local time
Today, 06:40
Joined
Oct 16, 2018
Messages
175
Re: Access error -queryW is corrupt

Hi Cliff. My guess is, if you see two buttons: Update Options and About Access, then you have C2R. How many buttons do you see?

:( two...I guess we just found out then :rolleyes:
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:40
Joined
Oct 29, 2018
Messages
21,357
Re: Access error -queryW is corrupt

:( two...I guess we just found out then :rolleyes:
Yes, I just confirmed it through this website. How are you dealing with the bug right now? Did you use the utility I posted, or do you want to revert your build number to the one prior to the broken build?
 

Cliff67

Registered User.
Local time
Today, 06:40
Joined
Oct 16, 2018
Messages
175
Re: Access error -queryW is corrupt

I had only one update query in the database so I created a query of the info I wanted to update then ran the update query on that query, a query on a query, not elegant but it worked well
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:40
Joined
Oct 29, 2018
Messages
21,357
Re: Access error -queryW is corrupt

I had only one update query in the database so I created a query of the info I wanted to update then ran the update query on that query, a query on a query, not elegant but it worked well
Okay. Glad to hear your situation was simpler than others. We'll let you know as soon as the situation changes. Cheers!
 

Cliff67

Registered User.
Local time
Today, 06:40
Joined
Oct 16, 2018
Messages
175
Re: Access error -queryW is corrupt

Cheers DBg
 

isladogs

MVP / VIP
Local time
Today, 13:40
Joined
Jan 14, 2017
Messages
18,186
Is anyone else experiencing the same issue as me.
Having applied the fix to both A2010 and A365 on several workstations, each has had the fix reversed at least once by subsequent updates.

Whilst its easy enough to reapply the fix, its becoming more than a little tiresome. I've now disabled updates on A365 where its happened twice and may well do so on A2010 workstations as well. However this runs the risk of not being protected against the latest security vulnerabilities.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 06:40
Joined
Aug 30, 2003
Messages
36,118
Re: Access error -queryW is corrupt

It hasn't happened to me, but I have heard of others experiencing it.
 

Users who are viewing this thread

Top Bottom