Forum Discussion
Run-Time Error 3340: Do NOT have problem updates installed
Like many others, I returned to work today (11/18) only to find our app spitting out this Run-Time 3340, query is corrupt error. I tried searching the latest updates for the problem updates (KB4484127, KB4484119, KB4484113, and KB3085368) and none of these are present on the machine in question. The developer for the app we're using also suggested trying a fix for office 365, which did not work (we don't, as far as I can tell, actually use office 365 on that machine, so I wasn't really expecting a fix there to work). Does anyone know of any other update that might be causing this issue? I am not technical enough to know where to begin with Microsoft's suggested code fix, and with none of the problematic updates being present, I'm stumped as to where else to look to fix the issue.
19 Replies
- Shane Groff
Microsoft
Hi. What version/build of Office do you have? (where to get this information unfortunately depends on which version/build you have, but try starting with File/Account or File/Help).
KB4484127 is specific to Office 2010, KB4484119 to Office 2013, and KB4484113/KB3085368 are for Office 2016 MSI installations.
If you don't have any of those updates, it suggests that you have either Office 2016 Click-to-run, or Officed 365. If you do, you can use File/Account/UpdateOptions/UpdateNow to get a fix for this issue.
If you have Office 2016 MSI, then there is a fix avaialbe here:
https://support.microsoft.com/help/4484198
For Office 2010/2013, a fix will be available soon.
Shane Groff
Access Engineering
Shane Groff I wanted to personally thank you for the help you provided @thefaydra regarding the "run-time error 3340: Do NOT have problem updates installed" issue. I have developed a database app over the past 20+ years that handles family financial management and personal investment management. Today I ran into the "Query is corrupt" issue while using my app to process some QCDs out of my IRA. I spent most of the afternoon trying to fix the issue without any success. Longer story short, I found your thread on this issue. Thank you so much! I ran the update and everything cleared up. What a relief!
Do you have an idea as to why this option does not show up in my Office365 menu? v1910 or v1902
"File/Account/UpdateOptions/UpdateNow to get a fix for this issue."
Thanks for any input!
- Shane Groff
lwestberg II'm not sure I understand your question.
When you choose 'File', then 'Account', what does it say under 'About Access'?
If it doesn't show a Version/Build number there, if you click on About About Access, then what build number does it show then?
Shane
thefaydra check if this helps :
To downgrade version, you need to launch CMD.EXE as Administrator and then add 2 lines:
[Office 2016/2019]
cd %programfiles%\Common Files\Microsoft Shared\ClickToRun
officec2rclient.exe /update user updatetoversion=16.0.12130.20272Office [2013 with windows 32-bit]
cd %programfiles%\Microsoft Office 15\ClientX86 officec2rclient.exe /update user updatetoversion=15.0.5179.1000
Office [2013 with windows 64-bit]
cd %programfiles%\Microsoft Office 15\ClientX64 officec2rclient.exe /update user updatetoversion=15.0.5179.1000
Hi I have the Spanish version of Office 2013 32 bits. I try your solution but is not working.
I am not find officec2rclient.exe in my computer.
Someone Knows when Microsoft will fixe the problem. They expected solve it the 29th, but not yet.
Regards from Spain and sorry by my English.
- Shane Groff
Are you certain that you have a C2R install?
If you start Access, click Open Other Files, then Click Account, do you see a button that says 'Update Now'? Or do you just see 'About Access' like this:
If you have an MSI installation, rather than C2R, you should install KB2965317
Shane
