Hi all
what is the problem in this code
i wrote it to update ms access table but it gives an error "Operation must use an updateable query."Code:Using cmd As New OleDb.OleDbCommand("update table1 Set column1= (SELECT Count(*) As CountOfID from table2)", con) con.Open() cmd.ExecuteNonQuery() con.Close() End Using
now I'm using Dcount instead but i want to find the problem
thanks in advance