To debug this, I would insert a messagebox to display the query string for #1. Maybe that would give a clue.

Re #3, the dataset requires that the primary key be included in the data.