Trying to open an Access 97 DB using Visual Basic

  • Thread starter Thread starter MurrayK
  • Start date Start date
M

MurrayK

Good Day,

I was wondering if anyone could point me in right direction. I'
trying to open a shared Access 97 (DAO/ADODB??) database using Visua
Basic. I need to do some comparisons on the composite key between
few tables. I want to grab the information from the tables and pu
them in an array to do my comparisons.

I added the ADODC component to my form but I'm missing something.

Public cn as New ADODC.Connection (I get a mismatch error here)
Public rs as New ADODC.Recordset

Private Sub cmdConnection_Click()

cn.ConnectionString = "provider=Microsoft.Jet.OLEDB.3.51;data sourc
c:\testconnection.mdb
cn.Open
Debug.Print "Connection Established"


End Sub
:confuse
 
I've never used bound controls, but I believe that the Connection object
comes from ADODB, not ADODC. (The difference is that ADODB is the core of
ADO, while ADODC is specific to the data control)
 
Back
Top