Update Query in MS Access

DKalepu

Hi all, how to write update Query in MS Access?? in sql, we write like this "update tablename set field = '"+ +"' where field= '"+ +"'";" but its giving an error whenever i write the same query in access...... so, could any one help me how to write "update Query in ms access plz/// Thanks in Advance.! :)

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!