Trying to update an Access DB using Oledbconnection.
Getting a syntax error (missing operator) in the SQL statement below, cannot see what it is can anyone help?
DBCommand = New OleDbCommand("SELECT * FROM Customer Where CustID = " &_ LBL_CustID.Text & " UPDATE Customer SET CustName = " & TXT_CustName.Text & " ", ManufacturingConn)
Is there a better way to do it?
