none
MS Access Runtime error 3340 RRS feed

  • Question

  • Hi all,

    Since this morning, my users are receiving the runtime error "3340 - Query is corrupt."

    I am not experiencing this error on my development PC, but almost all users do.

    The query that is running, is a UPDATE query (SQL Query)

    Sql = "UPDATE LogTable " _
        & "SET Program = 'Tripmaster' " _
        & "WHERE UserName = " & "'" & EmployeeName & "'" & ";"
    DoCmd.RunSQL Sql
    

    Our anti-virus is up to date. The only difference is that the network is very slow. Not sure if this can cause the error.

    Not sure what the cause may be as it does not happens to all users.

    Any suggestions will be appreciated.

    Thanks

    Deon

    Wednesday, November 13, 2019 1:51 PM

Answers

  • There is a workaround where you change your table name to query then update the query instead.

    see --> https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec?ui=en-US&rs=en-US&ad=US

    I hope Microsoft solve this problem soon because this doesn't make sense.

    Cheer.

    Chaivat Srisomvongse

    eMail : chaivats@hotmail.com


    Wednesday, November 13, 2019 2:59 PM

All replies

  • Take a minute to review the next post in this forum: https://social.msdn.microsoft.com/Forums/office/en-US/7e7f24cc-f1f3-43f8-a9a2-45b77812b211/the-cve20191402-updates-kb4484119-etc-break-access-201020132016365-query-is-corrupt?forum=accessdev


    -Tom. Microsoft Access MVP

    Wednesday, November 13, 2019 1:59 PM
  • There is a workaround where you change your table name to query then update the query instead.

    see --> https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec?ui=en-US&rs=en-US&ad=US

    I hope Microsoft solve this problem soon because this doesn't make sense.

    Cheer.

    Chaivat Srisomvongse

    eMail : chaivats@hotmail.com


    Wednesday, November 13, 2019 2:59 PM
  • Hi all,

    Yes, this is working partially. The only problem is that I need to change all my "UPDATE" statements and there are hundreds of them.

    I could identify which of these statements causes the error and fix only those statements. As the errors occur, I change the queries.

    Thanks for the assistance.

    Deon

    Monday, November 18, 2019 5:47 AM
  • Hi all,

    Yes, this is working partially. The only problem is that I need to change all my "UPDATE" statements and there are hundreds of them.

    I could identify which of these statements causes the error and fix only those statements. As the errors occur, I change the queries.

    Thanks for the assistance.

    Deon

    https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

    Just uninstall update or downgrade office version. Also dont forget to pause updates till december 10.


    Monday, November 18, 2019 8:30 AM
  • Just an FYI, Microsoft has just released the first patch for Access 2016 MSI

    You can download the patch from https://support.microsoft.com/en-us/help/44...-2016-kb4484198

    *** This is a manual patch, so it will not automatically be installed by Windows Update and you must download and install it yourself! ***

    As for the other versions/editions … patches should be coming soon.


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Monday, November 18, 2019 8:13 PM