error 430

E

EMP

I get the error 430 - Class does not support automation or
does not support expected interface. I am trying to get
data into my grid by using an ado control. I tried to
make sure I had the updated mdac, but I am still getting
the error. I think I have everything checked in the
references. I have the ado control on my form. I have my
code shown below. Maybe my connection to Access isn't
correct. I am using VB 6.0. Does anyone know what I am
doing wrong or had this problem before? Help!!

EMP




qryCustomer = "SELECT [cust_first_name],[Cust_Last_Name],
[Cust_Phone],[Cust_email],[Cust_title]" & _
" FROM Customer_Info" & _
" WHERE [Cust_Index_id] = " & iIndex & _
" ORDER BY [Cust_Last_Name]"

Call OpenConnection

With Adodc1
.ConnectionString = objADOConnect
.RecordSource = qryCustomer
.Refresh
End With

'- set header grid properties
DBGrid1.ClearFields
Set DBGrid1.DataSource = Adodc1 *** This is the problem

With DBGrid1
.AllowRowSizing = True
.ColumnHeaders = True
.Appearance = dbg3D
.AllowUpdate = False
.AllowAddNew = False
.AllowDelete = False
.ReBind
.Refresh
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top