Not able to add new record and insert record to MS access database using ADO Control

[mysore]

Hello,

I have several textboxes on my VB6.0 form.I am using textboxes one for each field. I have Placed adocontrol on my form to connect to MS access database. The connectivity is fine.

I have problem adding new record and inserting records to the database. For eg. I have a Insert button.

Private Sub Insert_Click()
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("First Name") = Form1.Text2.Text
Adodc1.Recordset.Fields("CaseNo") = Form1.Text1.Text

Adodc1.Recordset.Update.
End Sub

When I click on the Insert button, I get
" Run Time error 91", Object Variable not set". Th yellow error line is highlighted on Adodc1.....

I never had this problem before in my previous projects. It worked great. But suddenly , even a simple test project seems to get errors with ADO control.

Can you please help resolve this problem.

Thank You,
Pratibha

[thamaraikeeran]

hi pratibha,
please see this url http://www.startvbdotnet.com/ado/Simplebinding.aspx
it will help u.

[mysore]

Thanks. This really helps. I will try this .

Pratibha

hi pratibha,
please see this url http://www.startvbdotnet.com/ado/Simplebinding.aspx
it will help u.

[mysore]

hi pratibha,
please see this url http://www.startvbdotnet.com/ado/Simplebinding.aspx
it will help u.

It worked. Thanks.

Pratibha