Hi,

       What is the select command for SxAdapter?

Ken
--------------------------

Here is my GetData mod

Private Sub GetData(ByVal selectCommand As String)
       Try
           Dim Cxx As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source= " & Application.StartupPath & "\zAdmin.mdb;User Id=admin;Password=;"
           SQL = "Select LastName, FirstName, Date, Score from Scores"
           ' Create a new data adapter based on the specified query.
           SxAdapter = New OleDbDataAdapter(SQL, Cxx)
           Dim MyCommandBuilder As New OleDbCommandBuilder(SxAdapter)
           Dim SxTable As New DataTable()
           SxTable.Locale = System.Globalization.CultureInfo.InvariantCulture
           SxAdapter.Fill(SxTable)
           SxSource.DataSource = SxTable
       Catch ex As OleDbException
           MessageBox.Show("Error")
       End Try
   End Sub