Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    vad77 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Location
    USA
    Posts
    101

    Exclamation Error - Corrupt Update query

    I am getting a Corrupt Query error on Update queries. I did do a search and found all the posts from 2019 when this seem to first pop up. I am running Windows 10 1909 and Office 365 version 16.0.11328
    I get the error in the following scenario's
    1. New Select query not saved with criteria for one field and then set to Update query
    2. Saved Select query with criteria for a field then set to Update query.
    I do not get error when there is no criteria set for any of the fields. It only seems to happen when I set any type of criteria.
    Have another remote Windows 10 machine version 1809 and office 365 version 10.0.10730. No issues with that version, I can run update queries with no issue.
    Just noticed it yesterday while working on one of my DB.

  2. #2
    JoeM is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    3,904
    Are you sure that the database itself is not corrupt?
    If you trying copying all of the database objects over to a new database, does the new database exhibit the same issue?

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Doesn't the documentation show the version where this was fixed for every version of Office? Doesn't it also show a work around? It seems that you either need to update on the problem pc, or apply the work around so I'm not sure what you are asking for.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    vad77 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Location
    USA
    Posts
    101
    This is a split database that I first noticed the issue on. the BE is on network drive, FE on my machine. I have same FE on the other machine from my post linked to same BE. It works fine on the other machine. I also tried opening the BE directly and run an update query from there, same error. I have other databases on my machine, a mixture of split and not split. Every DB I try an update query on gives me the error.

  5. #5
    JoeM is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    3,904
    See Micron's comments.

  6. #6
    vad77 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Location
    USA
    Posts
    101
    Micron thank you for the reply. The issue started yesterday, I never had an issue running update queries in any of my databases before. There are times where I need to do a quick update to a bunch of records and just run a quick update query that I don't save when done. Cannot take a saved query and change it to an update query, that also gives me error. What I am trying to understand is why is this happening now when it never did before.

  7. #7
    JoeM is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    3,904
    It looks like you are using a version of Office 365 from August 2020, and there have been updates since.
    First thing you should do is make sure that you have applied all Windows and Office updates so you are current!

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    All I can think of is that you had a recent update that introduced a bug or your db is corrupt as was suggested. The latter is easy to test:
    - open a new db and import all forms, reports, macros, ribbons that were created
    - if you can update the table in question, import all tables as well during this import
    - import all queries as well, but not the problem query.
    - after the import, copy the sql of the problem query, create a new query in the new db and paste the sql into it
    - test

    Suggest you check your versions and install types against the info provided here
    https://support.microsoft.com/en-us/...3-f21636caedec
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  9. #9
    vad77 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Location
    USA
    Posts
    101
    My last two updates were 0n 3/10/2021. Could the first time I ran an update query since then but not sure.
    Also did what you suggested. Created new database and imported all items from other DB. Built new update query and pasted in SQL from existing DB, same result. Corrupt Query.

    Click image for larger version. 

Name:	DB_error.JPG 
Views:	11 
Size:	19.4 KB 
ID:	44868

  10. #10
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    IIRC, the reason this issue arose is because of an update, which then required an update to fix it. Being only a home user, I turned off updates a year ago for this very reason. Perhaps you could try rolling back your last update to see what happens - or employ the work around as suggested.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  11. #11
    JoeM is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    3,904
    You said:
    I am running Windows 10 1909 and Office 365 version 16.0.11328
    You also said:
    My last two updates were 0n 3/10/2021
    But according to this document here, the last 11328 build was in August 2020, and there have been newer builds since then.
    https://docs.microsoft.com/en-us/off...5-apps-by-date

    So it looks to me that you may not be on the most current version.

  12. #12
    vad77 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Location
    USA
    Posts
    101
    Last two security updates: March 9, 2021—KB5000808, KB5000908

  13. #13
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    IMO, Windows updates are irrelevant for this. What counts is Office updates, or specifically, updates to Access if the issue lies there and not in Office. Check your Access version against the documentation.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  14. #14
    vad77 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Location
    USA
    Posts
    101
    I'll do that thanks.

  15. #15
    vad77 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Location
    USA
    Posts
    101
    Thank you everyone for your replies and links. It seems I have the broken build if I read the list correctly, My Office 365 is: version 1902 11328.20468. Had my hard disk replaced with a SSD recently that is when most likely that is when the broken build installed. Now need to check with IT to see if I can get the fixed build installed.
    Again thanks to all. This Forum has been a great resource.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 12-06-2019, 12:22 PM
  2. query is corrupt
    By hendrikbez in forum Queries
    Replies: 4
    Last Post: 11-23-2019, 04:07 AM
  3. Corrupt Query
    By UT227 in forum Queries
    Replies: 4
    Last Post: 11-22-2019, 06:08 AM
  4. Replies: 12
    Last Post: 11-20-2019, 11:54 AM
  5. Replies: 4
    Last Post: 06-16-2018, 04:29 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums