Hello experts I am working on an application where I update the MsAccess database by coding. Now I am stuck with minor error but i did't able to rectify.
please tell me what's error in this code as it show me the syntax error
Private Sub updateAppNote()
If AppConn.State.ToString = "Closed" Then
Dim SQL As String = "UPDATE Applicant_Note " & _
"set Time_Stamp='" & Now.ToShortDateString & " " & Now.ToShortTimeString & "', Note='" & txtnote.txt & _
"' Where NID=" & CLng(dgvNoteList.CurrentRow.Cells(0).Value)
Dim Dc As New OleDbCommand(SQL, AppConn)