UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> ? Query Is Corrupt, Access 2016    
 
   
pacala_ba
post Nov 18 2019, 04:05 AM
Post#1



Posts: 670
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi
Query that was working on Friday, now gets Error
QUOTE
Query is corrupt...
pullhair.gif
may be some Microsoft Update behind the scene iconfused.gif

CODE
For i = 1 To References.Count: Debug.Print i, References(i).FullPath & ", MAJOR=" References(i).Major & ", MINOR=" References(i).MINOR & ", DATE="&   FF_TIME( References(i).FullPath): Next i
1            C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL, MAJOR=4, MINOR=2, DATE=17/10/2016 19:14:20
2            C:\Program Files (x86)\Microsoft Office\Office16\MSACC.OLB, MAJOR=9, MINOR=0, DATE=12/06/2018 05:37:50
3            C:\Windows\SysWOW64\stdole2.tlb, MAJOR=2, MINOR=0, DATE=18/03/2017 21:58:48
4            C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL, MAJOR=12, MINOR=0, DATE=15/01/2019 12:45:58
5            C:\Program Files (x86)\Common Files\System\ado\msado15.dll, MAJOR=6, MINOR=1, DATE=07/06/2019 06:27:49
6            C:\Program Files (x86)\Common Files\System\ado\msadox.dll, MAJOR=6, MINOR=0, DATE=07/06/2019 06:32:16
7            C:\Program Files (x86)\Common Files\System\ado\msjro.dll, MAJOR=2, MINOR=6, DATE=18/03/2017 21:58:42
8            C:\WINDOWS\SysWOW64\FM20.DLL, MAJOR=2, MINOR=0, DATE=31/07/2015 08:56:38
9            C:\Windows\SysWOW64\mshtml.tlb, MAJOR=4, MINOR=0, DATE=18/03/2017 21:59:49
10           C:\Program Files (x86)\Microsoft Office\Office16\EXCEL.EXE, MAJOR=1, MINOR=9, DATE=17/10/2019 10:28:36

This post has been edited by pacala_ba: Nov 18 2019, 04:14 AM

--------------------
Go to the top of the page
 
jleach
post Nov 18 2019, 04:19 AM
Post#2


UtterAccess Administrator
Posts: 10,281
Joined: 7-December 09
From: St. Augustine, FL


Hi - this is a bug introduced by an Office update. See here for full details:\

https://www.UtterAccess.com/forum/index.php...owtopic=2055753

--------------------
Jack D. Leach
Founder & CEO
Dymeng Services Inc.
Business Software Solutions
Go to the top of the page
 
DanielPineault
post Nov 18 2019, 06:54 AM
Post#3


UtterAccess VIP
Posts: 7,008
Joined: 30-June 11



It's a new bug caused by a series of flawed security updates (yes, some more!). You can learn everything there is to know about the issue and possible workarounds by reading

Access – Bug – Error 3340 – Query is corrupt

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
pacala_ba
post Nov 18 2019, 08:06 AM
Post#4



Posts: 670
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi
thanks.gif
AC.2016 works again after removing MS UPDATE KB4484113 woohoo.gif

--------------------
Go to the top of the page
 
DanielPineault
post Nov 18 2019, 09:37 AM
Post#5


UtterAccess VIP
Posts: 7,008
Joined: 30-June 11



We're always glad to help.

Please send feedback to Microsoft though that you were impacted by this bug. Vote on access.uservoice.com suggestions relative to this issue, call the support.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 04:12 AM