Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-15-2019, 03:36 AM   #1
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,063
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
error 3340 ‘Query is corrupted

After an end user got error 3340 ‘Query is corrupted, I started to get it today too.

It seems that Office November 2019 Updates are causing Access Error 3340

I don't see any office update, but it shows me as Office was installed today (Nov.15th)

How can I remove this update without Uninstalling Office

smig is offline   Reply With Quote
Old 11-15-2019, 03:43 AM   #2
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 218
Thanks: 40
Thanked 5 Times in 5 Posts
gstylianou is on a distinguished road
Re: error 3340 ‘Query is corrupted

Ηι,

See this important notice directly from Microsoft
Attached Images
File Type: jpg 1.JPG (41.0 KB, 201 views)
File Type: jpg 2.JPG (39.1 KB, 117 views)
File Type: jpg 3.JPG (35.8 KB, 73 views)
File Type: jpg 4.JPG (13.5 KB, 71 views)
gstylianou is offline   Reply With Quote
Old 11-15-2019, 03:48 AM   #3
bob fitz
AWF VIP
 
Join Date: May 2011
Location: Essex England
Posts: 3,535
Thanks: 52
Thanked 685 Times in 667 Posts
bob fitz has a spectacular aura about bob fitz has a spectacular aura about bob fitz has a spectacular aura about
Re: error 3340 ‘Query is corrupted

See this thread: https://www.access-programmers.co.uk...d.php?t=307918

__________________
Bob Fitzpatrick
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Many thanks.


I have never failed. I have found a thousand ways that do not work!
bob fitz is offline   Reply With Quote
Old 11-15-2019, 03:52 AM   #4
moke123
Me.Dirty=True
 
moke123's Avatar
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 791
Thanks: 3
Thanked 238 Times in 224 Posts
moke123 will become famous soon enough
Re: error 3340 ‘Query is corrupted

There's a link at the bottom of the link you posted with instructions.
moke123 is offline   Reply With Quote
Old 11-15-2019, 04:02 AM   #5
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,063
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: error 3340 ‘Query is corrupted

Quote:
Originally Posted by moke123 View Post
There's a link at the bottom of the link you posted with instructions.
File Not Found
smig is offline   Reply With Quote
Old 11-15-2019, 04:04 AM   #6
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,063
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: error 3340 ‘Query is corrupted

We'll continue with Colin's - Access error -query is corrupt
smig is offline   Reply With Quote
Old 11-15-2019, 05:22 AM   #7
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 218
Thanks: 40
Thanked 5 Times in 5 Posts
gstylianou is on a distinguished road
Re: error 3340 ‘Query is corrupted

Hello my friends,

First of all I would like to say that unfortunately in these cases we rely on Microsoft itself which is really indifferent to whatever problems it may cause to any users who have an Access application either in their business or even for personal use. Personally, till now i didn't yet seen any official apology from Microsoft for this problem which seems to affect almost everyone since a professional application is almost certain to include at least one update query.

I am going to talk about us which we are a small developer company (4 developers) and we have already created dozens of applications with Ms Access that have been sold to several of customers and already we are constantly receiving complaints about this problem from almost everyone. Microsoft announces that it will fix the problem in a future update (December 10th) and is indifferent that we need to find an immediate solution for all customers facing this problem now, not on December 10th.!!!! Until then, all developers are urged to spend tens of hours eachone in order to makes the urgent modification which microsoft proposes to those who can't wait for the new update in almost 1 month (!!) from now.

For those of you who are interested in the solution which Microsoft suggests, i will let you know that already it has been tested by us and indeed the problem is solved as following below
Attached Images
File Type: jpg Solution.JPG (65.5 KB, 237 views)

gstylianou is offline   Reply With Quote
Old 11-15-2019, 05:30 AM   #8
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 218
Thanks: 40
Thanked 5 Times in 5 Posts
gstylianou is on a distinguished road
Re: error 3340 ‘Query is corrupted

Quote:
Originally Posted by smig View Post
After an end user got error 3340 ‘Query is corrupted, I started to get it today too.

It seems that Office November 2019 Updates are causing Access Error 3340

I don't see any office update, but it shows me as Office was installed today (Nov.15th)

How can I remove this update without Uninstalling Office
See post 7
gstylianou is offline   Reply With Quote
Old 11-15-2019, 06:13 AM   #9
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,063
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: error 3340 ‘Query is corrupted

Quote:
Originally Posted by gstylianou View Post
See post 7
I totaly agree with you
Where is the solution in your post?
smig is offline   Reply With Quote
Old 11-15-2019, 06:34 AM   #10
moke123
Me.Dirty=True
 
moke123's Avatar
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 791
Thanks: 3
Thanked 238 Times in 224 Posts
moke123 will become famous soon enough
Re: error 3340 ‘Query is corrupted

Quote:
Originally Posted by smig View Post
https://docs.microsoft.com/en-us/off...install-office
moke123 is offline   Reply With Quote
Old 11-15-2019, 06:40 AM   #11
gstylianou
Newly Registered User
 
Join Date: Dec 2013
Posts: 218
Thanks: 40
Thanked 5 Times in 5 Posts
gstylianou is on a distinguished road
Re: error 3340 ‘Query is corrupted

Quote:
Originally Posted by smig View Post
I totaly agree with you
Where is the solution in your post?
Check my attached image on Post 7
gstylianou is offline   Reply With Quote
Old 11-15-2019, 06:57 AM   #12
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,326
Thanks: 115
Thanked 3,101 Times in 2,819 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: error 3340 ‘Query is corrupted

Further info on various work-rounds and on ways of removing the update in my sticky thread:
https://www.access-programmers.co.uk...d.php?t=307918

I've just added instructions on how to remove the Nov update if you have Office 365
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-20-2019, 05:01 AM   #13
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,826
Thanks: 56
Thanked 1,031 Times in 997 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: error 3340 ‘Query is corrupted

I had the issue. and was able to restore O365 to the previous version, until its safe to resume automatic updates. There was a worse problem last year.

I thought my users also had a problem writing data directly to a table opened in a recordset, as well as the single table queries failing.

MS "solution" seemed just totally impractical. Check and re-write every append query (maybe update query as well)? Really?

Anyway for O365, I used a variation of this solution, as there is no uninstall option for click to run access.

https://www.cnet.com/how-to/how-to-r...of-office-365/


I added what I thought was another note to this thread, but it actually posted in another thread. Anyway A2003 is not affected by this, if anyone is still using old time access.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.

Last edited by gemma-the-husky; 11-20-2019 at 05:09 AM.
gemma-the-husky is offline   Reply With Quote
Old 11-20-2019, 01:39 PM   #14
MrHans
Registered User
 
Join Date: Jul 2015
Location: NL - Amsterdam
Posts: 141
Thanks: 58
Thanked 19 Times in 17 Posts
MrHans is on a distinguished road
Re: error 3340 ‘Query is corrupted

We also use O365 in our office.
The problem started about two days ago for us.

Today I performed the normal manual office procedure within any Office application as described earlier and the problem was immediately solved.

No need to uninstall anything, just perform a manual update and you're good to go
MrHans is offline   Reply With Quote
Old 11-21-2019, 12:09 AM   #15
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,826
Thanks: 56
Thanked 1,031 Times in 997 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: error 3340 ‘Query is corrupted

@MrHans.

@Colin/Isladogs indicated elsewhere that MS have already released fixes for some builds of Access/Office

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Corrupted db ellenr General 10 12-26-2017 09:00 AM
Query gets corrupted when a criteria is specified? tangcla Queries 20 11-30-2009 07:35 PM
How can I tell if FE is corrupted? Error with JET utility. RCurtin General 5 05-22-2006 05:31 AM
Corrupted form by modifying query? NJudson Forms 0 07-16-2004 02:06 PM
VBA Corrupted fmm Modules & VBA 0 04-15-2002 01:08 PM




All times are GMT -8. The time now is 09:39 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World