473,715 Members | 2,878 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Query is corrupt error message 11-14-2019

79 New Member
All of sudden, many vba functions in my Access application using query are not working with error message "Query is Corrupt".

Google results has one page from Microsoft dated 11/14/2019 referring the issue to a patch updates for MSI of several builds.

Does anyone know when MS will fix this issue? Will it be automatically repaired when fix is done by MS or is there some steps we need to do to fix the problem?
Nov 15 '19 #1
13 2662
DJRhino1175
221 New Member
I was getting a lot of corruption issues awhile back and the only thing I could find that fixed my issues was a registry fix. I had to put it on every PC that uses access. I haven't had corruption since.

Expand|Select|Wrap|Line Numbers
  1. Windows Registry Editor Version 5.00
  2. [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]
  3. "FileInfoCacheLifetime"=dword:00000000
  4. "FileNotFoundCacheLifetime"=dword:00000000
  5. "DirectoryCacheLifetime"=dword:00000000
Save it in a .txt file as whatever name .reg

Hopefully that will work out for you.

You will probably have to fix your query to and any other objects that are not working in the database.

Good Luck
Nov 15 '19 #2
cactusdata
214 Recognized Expert New Member
There is an official page on that issue:

Access error: "Query is corrupt"
Nov 15 '19 #3
Joe Y
79 New Member
The page from Microsoft I found from Google results is -

https://support.office.com/en-us/art...3-f21636caedec
Nov 15 '19 #4
Joe Y
79 New Member
There is a workaround suggested by the support page. However, I have lots of VBA using query. Making each change is going to be a big challenge.
Nov 15 '19 #5
Joe Y
79 New Member
DJRhino1175,

I've never dealt with registry. Can you guide me through where to save the .reg file? Most of the users are using Windows 10 pro, some are Windows 7 Pro.

Thanks in advance!
Nov 15 '19 #6
NeoPa
32,569 Recognized Expert Moderator MVP
Hi Joe.

Let's deal with this one point at a time :
  1. I suspect that DJRhino's suggestion will not pertain to this issue. That is not to say, by any stretch of the imagination, that DJ wasn't being helpful and sharing his past experiences with you. Simply that his solution looks like it may be for another problem altogether.
  2. I strongly recommend to you, and anyone that doesn't themselves have a good understanding of the Registry in Windows or how one can update it safely, that you don't go there. Every responsible web page ever written that includes instructions on such amendments always includes very strong warnings. If you aren't sure - don't go there.
  3. The page you found on Google is exactly the same one that CactusData posted for you some four hours previously.
  4. You may want to revisit that page. Everyone in the Access world seems to be suffering badly from this issue and everyone is talking about it. As you'd expect, those involved at MSFT, as well as many other prominent faces in the Access world that work in this area, are working very hard to get this resolved. The current version of the page gives various options - most of which depend on the version(s) of Access you're using.
  5. Joe Y:
    Making each change is going to be a big challenge.
    It certainly is. Get your head around that and get on with it, is my best advice. You won't be unique in having to and there will certainly be help and support for all those, like yourself, who've been caught out by this issue.

As a last contribution, and though these are actually commercial sites and so normally unacceptable on Bytes.com, they are helpful in a very serious situation and are both by MVPs working closely with MSFT - the producer of the software, so I will include them :
Critical: Office Update breaks Access ó Query is corrupt
Microsoft Access Query is Corrupt Error 3340
Nov 16 '19 #7
NeoPa
32,569 Recognized Expert Moderator MVP
@DJRhino.

I believe that .REG files must actually be stored as UNICODE, rather than simple ASCII text as you'd normally find when creating a new document in most text editors. Many handle UNICODE if the file is already encoded that way - and of course for the most part they would look the same, but don't be confused into thinking they're standard ASCII text files.

I'm not pushing the use of .REG files you understand, just explaining a potential confusion in the hope that it may help.

The easiest way to create a workable .REG file is to select a part of the Registry tree within RegEdit.Exe and Export it from the Right-Click menu. That file will, necessarily, be encoded the right way for importing into a Registry tree at some other time.

NB. *** NEVER PLAY WITH THE REGISTRY ***
When you know enough to ignore this warning then you already know the dangers and that you hold full responsibility for all the results - intended & unintended.
Nov 16 '19 #8
Joe Y
79 New Member
Thanks for the advice. Iím working on the workaround suggested by Microsoft. Letís hope they issue the fix soon.
Nov 17 '19 #9
NeoPa
32,569 Recognized Expert Moderator MVP
I'm sorry I couldn't give you better news :-(

I strongly expect that a fix will come out very soon (Sorry - I really can't be more specific.), but I also believe that it's unlikely to be soon enough for most users to get away without having to handle this locally in one way or another.

Releasing a fix to the whole world for a problem that's only just been discovered is always going to be a gargantuan task. Timescales will never match user requirements in those situations.

I wish you the best of luck - of course - as I do everyone who's been affected by these patch releases.
Nov 18 '19 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
1975
by: N. Graves | last post by:
Hello, I don't understand this error message." Error accessing File. Network Connection may have been lost." I'm not using any network connection for the database. In the VBA editor is goes to "Private Sub Form_DblClick(Cancel As Integer)". I have been making a bunch of changes and I'm sure I have done something to corrupt this mdb but I don't know where to start of this one. I hope there is help for me...
1
7868
by: iam247 | last post by:
Hi I am a relative beginner with SQL and ASP. With some help after previous posts I have a page which successfully requests querystrings from another page and deletes a record from an access table, However, I get the error message: "Row handle referred to a deleted row or a row marked for deletion" I am using access 2002, the table only has 2 fields (ContactID and
14
1724
by: Tom | last post by:
Using AccessXP in 2000 mode. I have the following tables --- TblLocation LocationID PropertyID StateID CountyID CityID
3
2834
by: Trevor Andrew | last post by:
Hi There, I have a small ASP.NET application under development. I am using VS.NET 2002 (2003 upgrade is on the way) with .NET Framework 1.1. It is hosted on a web hosting service in the US. I am experiencing the "Viewstate corrupted" error message on a particular page, when that page is left for a period of time and I return to it again, and submit it again. The page in question has a drop-down list of various RSS news feeds I am...
3
5123
by: Robert | last post by:
Every time I navigate to any .aspx file on my computer, I get the error below. According to MSDN this indicates that my CLR is corrupt, but I've re-installed the .NET framework with no help. Also reinstalled VS.NET; still nothing. Any ideas? Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code...
4
1145
by: TJS | last post by:
When trying to delete a row from a datagrid I get this error on every record regardless of record selected to delete. "Index 7 is not non-negative and below total rows count." there are 8 rows in the table being edited so index 7 should be a valid number ========= the offending code ================= Private _dataGridData As New DataTable()
8
3769
by: Alpha | last post by:
I created the following code in my C# program but it's giving me error message at run time of : XML.XPATH.XPATHEXCEPTION : Namespace Manager or XSLTContext needed. This query has a prefix, variable or user defined function. Can someone see what I'm doing wrong? Thanks, Alpha private XPathDocument unityMessages = new XPathDocument("UnityMessages.xml");
7
2118
by: Comagmbh | last post by:
Hello! I am new to this group and I hope anyone can help me. I have an error message which is very complicated to me. Okay this message is very simpel, but I don`t understand how to build my SQL statement. I use MsSQL 2000 and I am new to Microsoft SQL. I have searched the web and read the online help, but it is strange to me. At first here is my statement: SET QUOTED_IDENTIFIER ON
3
1426
by: sillyr | last post by:
Hi - I use Access 2007 and have a an issue I haven't encountered until now. My users enter data into a form that sends the data to two linked tables. One table worked fine and all of the data was there, but the other table had an error message when I tried to open it.- Error Message- Cannot open the database 'Commercial table'. It may not be a database that your application recognizes, or the file may be corrupt. The data is still on the...
1
31344
by: mabubakarpk | last post by:
I am using asp.net framework 2.0. I am facing following error message "Attempted to read or write protected memory. This is often an indication that other memory is corrupt" For more detail Plz see the attached file. Any one can help. Thanks in advance.
0
8821
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8718
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9340
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9047
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6646
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Duprť who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5967
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4738
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2539
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2118
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.