Update Query in MS Access

[Robert Rohde]

Hi, your syntax is principally correct. What error are you getting? Robert

[Muhammad Gouda]

"update tablename set field = '"+ +"' where field= '"+ +"'";" If the above is exactly your code. It is a matter of c# syntax Actually you have redundant " The correction is "update tablename set field = '"+ +"' where field= '"+ +"';" Also, you can truncate the smicolon of the query "update tablename set field = '"+ +"' where field= '"+ +"'" I hope this helps :laugh::laugh:

Mohamed Gouda Egypt

[DKalepu]

Hi, its saying "Syntax error in UPDATE statement" :confused:

[DKalepu]

Hi, thanks for the reply... i have tried these two cases: its giving error like " ; expected " actually this is my query statements:: string strQuery = "update UserInfo set Password = '"+ txtNewPwd.Text +"' where Password = '"+ txtOldPwd.Text +"'"; any other solution plz...

[Muhammad Gouda]

Make sure you use the correct spacing However, set a break point at that statement and debug to wathc the string

Mohamed Gouda Egypt

[DKalepu]

well, i did debug using break point.. Actually, it is executing the code step by step but at the end of the debugging a message box displayed "syntax error in UPDATE statement" ..

[Muhammad Gouda]

string strQuery = "update UserInfo set Password = '"+ txtNewPwd.Text +"' where Password = '"+ txtOldPwd.Text +"'"; In the aove string you need to take space before WHERE Note that 'where is COMPLETELY different from ' where This missed space makes the error

Mohamed Gouda Egypt

[DKalepu]

there is space b/w ' & WHERE........ :confused: :((

[Robert Rohde]

It might be that Password is a keyword in Access try: string strQuery = "update UserInfo set \"Password\" = '"+ txtNewPwd.Text +"' where \"Password\" = '"+ txtOldPwd.Text +"'"; Robert

[DKalepu]

Hi, thanks for the help! yes, Password is a keyword in Access. I have changed it to "pwd" & it worked very well....... Thanks!