Hello, I can't update my database. Why??? I found code snippets in thius forum, mine is the same. Here's the code:
VB Code:
  1. Dim myConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source=" _

  2. & "c:\mypath\db.mdb" ' Put here the connection string

  3. Dim myConnection As New OleDbConnection(myConnString) 'Create a new connection

  4.  
  5. Dim MyDataSet As New DataSet()

  6. Dim MyDataAdapter As New OleDbDataAdapter("SELECT * from MyTable", myConnection)

  7. MyDataAdapter.Fill(MyDataSet, "MyTable")

  8. MyDataSet.Tables(0).Rows(0).Item(2) = 123412 'modify 3nd column of first row

  9. MyDataAdapter.Update(MyDataSet) 'Here's the error
The error is: "Update was not able to find TableMapping['Table'] or DataTable 'Table'".

Thnx
Xmas