[solved]Data Provider or other service returned an E_FAIL Status

Hi guys ,
i have receieve this error when i was using ado controls to add entry to a mdb database.

Code:

---

If Template <> "" Then
  myData.Recordset.Fields("Template1") = Template
  myData.Recordset.Update
 End If

---

In mine form_load()

Code:

---

UserData.RecordSource = "select * from thumbprint"

---

SO does anyone know what is wrong or how does this error occur ..