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
