Issues with update sql command on OleDb Database

[eddyman592]

i'm writing a visual basic front end with ms access as the database. I'm using the OleDb type as the connection. All the other sql commands are working, but I'm having a problem with one.

I'm trying to update, using:

"update <table> set [column1] = [parameter1] where [column2] = [parameter2]"

it's just not doing anything. What is going on?

Thanks for any and all help.

[debasisdas]

Are you sure the condition in the where clause satisfies in the update query ?

[prakashsakthivel]

Are you sure the condition in the where clause satisfies in the update query ?

Hi

Whenever we use update query, Primary key should be in where caluse
so that Each row can be identified uniquely by that key
Make sure whether is it correct or not.

Regards

Prakashsakthive l