C# MS Access OleDb can't make write operations

I have a database in MS Access and I am trying to edit the table (db). SELECT works for me but edit operations like INSERT, SET and DELETE does not change anything.

I have this code below that deletes all rows. Initally there are 3 rows in the table, when I run the code output of affected rows is 3 but nothing is changed in the table.

static void Main(string[] args)
        {
            DeleteRow();
        }
        
        static void DeleteRow()
        {
            OleDbConnection connection = new OleDbConnection(connectionString);
            connection.Open();
            OleDbCommand command = new OleDbCommand();
            command.Connection = connection;
            command.CommandText = "DELETE FROM db";
            Console.WriteLine(command.ExecuteNonQuery());
            connection.Close();
            Console.ReadKey();
        }

I am using VS 2022 and when I run the query through server explorer it succesfully deletes the rows.

From the OleDBConnection documentation:

> The Close method rolls back any pending transactions. It then releases
> the connection to the connection pool, or closes the connection if
> connection pooling is disabled.

You should try to commit the transaction before closing.