title: INSERT INTO and UPDATE SQL using visual basic into access database
body: <p>I'm working on my A Level coursework using VB forms as my front end and an Access database as the back end. I've tried loads of different ways but I can't get the program to update or insert data into the database.
  I know for a fact the connection is fine because I've had no problem retrieving data from access into the program. </p>
  
  <p>This the code for one of the forms:
  (the database connection is in a separate form)</p>
  
  <pre><code>Access.ExecQuery("SELECT * FROM Exam;")
          Dim user As String = TxtStudent.Text
          Dim board As String = CmbBoard.Text
          Dim instrument As String = CmbInstrument.Text
          Dim grade As String = CmbGrade.Text
          Dim result As String = CmbResult.Text
  
  
          Access.ExecQuery("INSERT INTO Grade (Username, Instrument, Exam Board, Grade, Result) VALUES ('" &amp; user &amp; "', '" &amp; board &amp; "', '" &amp; instrument &amp; ", " &amp; grade &amp; ", " &amp; result &amp; "');")
          If Not String.IsNullOrEmpty(Access.Exception) Then MsgBox(Access.Exception) : Exit Sub
  </code></pre>
  
  <p>The error message says there is a syntax error on INSERT INTO statement.
  Am i just being really stupid? </p>