I'm using a typed dataset to retrieve data from an access db. The retrieval works fine; the disconnected datatable updates fine but the dataset does not update the database when I use adapter.dataset.update function. Please help. Neither works.

VB Code:
  1. Dim myDataRow As DataRow

  2.  
  3. myDataRow = Me.DsDefault.tb_users.NewRow()

  4. myDataRow("fname") = strFname

  5. myDataRow("lname") = strLname

  6. myDataRow("phone") = strPhone

  7. myDataRow("address") = strAddress

  8. myDataRow("city") = strCity

  9. myDataRow("current_flag") = intFlag

  10. myDataRow("state") = strState

  11. myDataRow("zip") = strZip

  12. myDataRow("fax") = strFax

  13. myDataRow("contact") = strContact

  14. myDataRow("date_added") = strDateAdded

  15.  
  16. Me.DsDefault.tb_users.Rows.Add(myDataRow)

  17. Debug.WriteLine("After Add Row: " & myDataRow.RowState.ToString)

  18.  
  19. Me.tb_usersTableAdapter.Update(Me.DsDefault.tb_users)

  20.  
  21.  
  22. '======Update datarow routine ========

  23. Dim myDataRow As DataRow = Me.DsDefault.tb_users.Rows(intRow)

  24.  

  25. myDataRow = Me.DsDefault.tb_users.NewRow()

  26. myDataRow("fname") = strFname

  27. myDataRow("lname") = strLname

  28. myDataRow("phone") = strPhone

  29. myDataRow("address") = strAddress

  30. myDataRow("city") = strCity

  31. myDataRow("current_flag") = intFlag

  32. myDataRow("state") = strState

  33. myDataRow("zip") = strZip

  34. myDataRow("fax") = strFax

  35. myDataRow("contact") = strContact

  36. myDataRow("date_added") = strDateAdded

  37.  
  38. Debug.WriteLine("After Edit Row: " & myDataRow.RowState.ToString)

  39.  
  40. Me.tb_usersTableAdapter.Update(Me.DsDefault.tb_users)