i get this error when i click on my update button:
Syntax error in UPDATE statement.

my primary key is in column(0) but i hide this column from the user
am i setting up my update command correctly?

vb.net Code:
  1. Private cnxnString As String = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\SaturationTags.mdb")
  2.     Private cnxn As New System.Data.OleDb.OleDbConnection(cnxnString)
  3.     Private sql As New System.Data.OleDb.OleDbCommand
  4.     Private myDataAdapter As New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [tblFields]", cnxn)
  5.     Private cmdBuilder As New System.Data.OleDb.OleDbCommandBuilder(myDataAdapter)
  6.     Private dbTable As New DataTable
  7.  
  8.     Public Sub frmDisplayFields_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
  9.         myDataAdapter.Fill(dbTable)
  10.         With DataGridView1
  11.             .DataSource = dbTable
  12.             .AllowUserToAddRows = False
  13.             .AllowUserToDeleteRows = False
  14.             .AllowUserToOrderColumns = False
  15.             .AllowUserToResizeColumns = False
  16.             .AllowUserToResizeRows = False
  17.             .Columns(0).Visible = False
  18.             .Columns(1).ReadOnly = True
  19.             .Columns(2).Width = 200
  20.         End With
  21.     End Sub
  22.  
  23.     Private Sub cmdDone_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDone.Click
  24.         myDataAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand
  25.         myDataAdapter.Update(dbTable)
  26.     End Sub