Update in access database

Question

Hi,

I am trying to update a column with the access databse it has been 2 hours now with no result I am writing different update queries and either I am getting syntax error in the update statement or they are updating my column but adding 0 in the place of the older value although that I am specifying a value, what's the problem how can I update a value with the access database using C#?

thanks.

Answer 1

Although I knew that Password was a reserved word in MS Access I didn't know that Username was. See list here:

http://support.microsoft.com/kb/321266 

However, it's good practice (and never does any harm) to enclose all your field names in square brackets just in case they happen to be reserved words :)

Answer 2

finally I knew where the problem was I needed to add [] to the columns name:
string edit = @"UPDATE Users SET [Password] = '" + TextBox2.Text + "' WHERE [Username] ='" + TextBox1.Text+"'";

thanks.