error on ExecuteNoQuery()

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

Make sure that ID isn't an IDENTITY column.

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

Now it's working fine MS SQL Server.