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.

Vulpes · Answer

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 :)

abed akhi · Answer

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.