以编程方式使用C#更新MS Access数据库中的链接表

using System;
using System.Data;
using System.Data.OleDb;

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\mydatabase.accdb;Persist Security Info=False;";

        using (OleDbConnection connection = new OleDbConnection(connectionString))
        {
            connection.Open();

            string sql = "UPDATE LinkedTable SET Field1 = 'NewValue' WHERE ID = 1";

            using (OleDbCommand command = new OleDbCommand(sql, connection))
            {
                command.ExecuteNonQuery();
            }
        }
    }
}