"错误:System.Data.OleDb.OleDbException(0x80004005):以下查询已损坏:'' [英] "Error: System.Data.OleDb.OleDbException (0x80004005): The following query has been corrupted: ''

问题描述

今天早上，该程序停止运行，并显示此错误消息.其他人只能在我的机器上使用.该程序已经运行了两年，到目前为止，尚未发生任何此类错误.可能是什么原因?自昨晚以来没有任何变化. 我还重新安装了ACCESS 2016 64x运行时，但不幸的是它没有改善.

This morning the program stopped running with this error message. Only works on my machine, everyone else. This program has been running for two years and no such bug has occurred so far. What could be the reason? Nothing has changed since last night. I also reinstalled the ACCESS 2016 64x runtime, but unfortunately it did not improve.

这是更新方法的一部分:

This is a part of the update method:

string _AccessOperation_command = "UPDATE [" + targettables.Trim() + "] SET " + subcommandUpdatestring +
                                       " WHERE " + wherecondition.Trim();

    OleDbCommand update_dbCommand = new OleDbCommand(_AccessOperation_command, myConn);
    for (int i = 0; i < tombmeret; i++)
    {
       update_dbCommand.Parameters.AddWithValue("@" + targetField_intoValue[i, 0], targetField_intoValue[i, 1]);
    }

    try
    {
      var rowsAffected = update_dbCommand.ExecuteNonQuery();
      successUpdate = true;
    }
    catch (Exception ex)
        {
          _MasterErrorText = "Error: " + ex;
          successUpdate = false;
          return successUpdate;
        }

    return successUpdate;

推荐答案

我发现了一个错误，不幸的是，我需要卸载最新的Office ACCESS2016安全更新.只有这样才能解决.

I found a bug, unfortunately I need to uninstall the latest Office ACCESS2016 security update. only this will solve it.

这篇关于"错误:System.Data.OleDb.OleDbException(0x80004005):以下查询已损坏:''的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！