Update table

[Maddy40]

Does anyone know why this code works with insert but not when i attempt an update both lines of code are there one works update dosnt?



__________________CODE_________________________

mysql = "INSERT INTO Table1(Name)VALUES('Reece')"
'mysql = "UPDATE (Table1) set Name ='Reece' WHERE Name =Luke"
cmd = New OleDbCommand(mysql)
cmd.Connection = cnn
cmd.ExecuteNonQuery()

_________END_CODE_________________________________

 

[Maddy40]

Fixed

fixed it my self

mysql = "UPDATE Table1 set Name='Reece' WHERE Name ='Cameron'"
cmd = New OleDbCommand(mysql, cnn)
cnn.Open()
cmd.ExecuteNonQuery()
cnn.Close()