C# i Access: Ldb fajl ostaje iako sam uradio con.Close()

Code:

con.Close();
con.Dispose();

Code:

            while (con.State != ConnectionState.Closed)
            {
                con.Close();
            }

Code:

string connectReport = "Provider=Microsoft.JET.OLEDB.4.0;data source=" + MyClass.dbName;
OleDbConnection conReport1 = new OleDbConnection(connectReport);
conReport1.Open();

/* delete all records from report table */
sql = "delete from DataUnion";
OleDbCommand cmdTruncate = new OleDbCommand(sql, conReport1); // creating query command
OleDbDataReader readerTrncate = cmdTruncate.ExecuteReader(); // executes query
//Console.WriteLine(sql);
cmdTruncate.Dispose();
while (conReport1.State != ConnectionState.Closed)
{
    conReport1.Close();
    conReport1.Dispose();
}


OleDbConnection conReport2 = new OleDbConnection(connectReport);
conReport2.Open();
/* Reset autoNumer value */
/* puca u ovom delu, predpostavljam da nije zavrsio brisanje selektovanih recorda iz predhodnog dela */
sql = "ALTER TABLE DataUnion ALTER COLUMN Id COUNTER(1,1)";
OleDbCommand cmdReset2 = new OleDbCommand(sql, conReport2); // creating query command
OleDbDataReader readerReset2 = cmdReset2.ExecuteReader(); // executes query
cmdReset2.Dispose();
while (conReport2.State != ConnectionState.Closed)
{
    conReport2.Close();
    conReport2.Dispose();
}