"Error: System.Data.OleDb.OleDbException (0x80004005): The following query has been corrupted: ''

3

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;
c#
ms-access-2016
asked on Stack Overflow Nov 13, 2019 by Juhász Lajos • edited Nov 13, 2019 by theduck

1 Answer

0

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

answered on Stack Overflow Nov 13, 2019 by Juhász Lajos

User contributions licensed under CC BY-SA 3.0