执行查询DoCmd.RunSQL时出现错误3340查询''已损坏 [英] Getting Error 3340 Query ' ' is corrupt while executing queries DoCmd.RunSQL

问题描述

因为安装了 Office 2010的Windows更新已解决KB 4484127 ，我在执行包含WHERE子句的查询时遇到错误.

Since installing the windows update for Office 2010 resolving KB 4484127 I get an error while executing queries which contain a WHERE clause.

例如，执行以下查询:

DoCmd.RunSQL "update users set uname= 'bob' where usercode=1"

导致此错误:

错误号= 3340查询''已损坏

Error number = 3340 Query ' ' is corrupt

更新为问题当前仍已安装:

如何成功运行查询?我应该只卸载此更新吗?

How can I successfully run my queries? Should I just uninstall this update?

推荐答案

摘要

这是

Summary

This is a known bug caused by the Office updates released on November 12, 2019. The bug affects all versions of Access currently supported by Microsoft (from Access 2010 to 365).

此错误已修复.

• 如果您使用Office的C2R(即点即用)版本，请:
  • Access 2010 C2R:已在内部版本7243.5000中修复
  • Access 2013 C2R:已在内部版本5197.1000中修复
  • Access 2016 C2R:已在内部版本12130.20390中修复
  • Access 2019(v1910):已在内部版本12130.20390中修复
  • Access 2019(批量许可证):已在内部版本10353.20037中修复
  • Office 365每月频道:已在内部版本12130.20390中修复
  • Office 365半年:已在内部版本11328.20480中修复
  • Office 365半年扩展版:已在内部版本10730.20422中修复
  • Office 365半年度定位:已在内部版本11929.20494中修复
  • If you use a C2R (Click-to-Run) version of Office, use "Update now":
    • Access 2010 C2R: Fixed in Build 7243.5000
    • Access 2013 C2R: Fixed in Build 5197.1000
    • Access 2016 C2R: Fixed in Build 12130.20390
    • Access 2019 (v1910): Fixed in Build 12130.20390
    • Access 2019 (Volume License): Fixed in Build 10353.20037
    • Office 365 Monthly Channel: Fixed in Build 12130.20390
    • Office 365 Semi-Annual: Fixed in Build 11328.20480
    • Office 365 Semi-Annual Extended: Fixed in Build 10730.20422
    • Office 365 Semi-Annual Targeted: Fixed in Build 11929.20494
    • Access 2010 MSI:已在 KB4484193
    • Access 2013 MSI:已在 KB4484186
    • Access 2016 MSI:已在 KB4484180
    • Access 2010 MSI: Fixed in KB4484193
    • Access 2013 MSI: Fixed in KB4484186
    • Access 2016 MSI: Fixed in KB4484180

    这是一个最小的复制示例:

    Here is a minimal repro example:

    1. 创建一个新的Access数据库.
    2. 使用默认ID字段和Long Integer字段"myint"创建一个新的空表"Table1".

    3. 在VBA编辑器的即时窗口"中执行以下代码:

    1. Create a new Access database.
    2. Create a new, empty table "Table1" with the default ID field and a Long Integer field "myint".

    3. Execute the following code in the VBA editor's Immediate Window:

    CurrentDb.Execute "UPDATE Table1 SET myint = 1 WHERE myint = 1"

    预期结果:该语句成功完成.

    实际结果，其中安装了一个有问题的更新之一:发生运行时错误3340(查询"已损坏").

    Actual result with one of the buggy updates installed: Run-time error 3340 occurs ("Query '' is corrupt").

    相关链接:

    • 此错误的官方Microsoft页面
    • MSDN forum thread
    • Official Microsoft page for this bug

    这篇关于执行查询DoCmd.RunSQL时出现错误3340查询''已损坏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！