Loading

Update in access database

abed akhi

14y1.9k.NET

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted 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 akhi14y ago
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.