error on ExecuteNoQuery()

Question

hey,

i'am trying to update a row in a table using :

command.ExecuteNoQuery()

it's not giving me an error but it's not updating the row

This is my code :

Dim req As String = "Update Table Set Id= 5"
Dim cmd As New OleDb.OleDbCommand(req, connect())
cmd.ExecuteNonQuery()
disconnect()

thanks

Answer 1

Make sure that ID isn't an IDENTITY column.

Answer 2

the problem is that the query was too slow with MS Access.

Now it's working fine MS SQL Server.