| | |
|
|
|
Trying to open an Access 97 DB using Visual Basic |
|---|
| message from MurrayK on 10 May 2004 |
Good Day,
I was wondering if anyone could point me in right direction. I'm
trying to open a shared Access 97 (DAO/ADODB??) database using Visual
Basic. I need to do some comparisons on the composite key between a
few tables. I want to grab the information from the tables and put
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 source
c:\testconnection.mdb
cn.Open
Debug.Print "Connection Established"
End Sub
:confused
|
| Pieter Wijnen replied to MurrayK on 11 May 2004 |
use adodb instead of adodc ?
Pieter
"MurrayK" <MurrayK.162s9z@nospam.MSAccessForum.com> wrote in message
news:MurrayK.162s9z@nospam.MSAccessForum.com...
|
| Douglas J. Steele replied to MurrayK on 11 May 2004 |
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)
|
|
Archived message: Trying to open an Access 97 DB using Visual Basic (MS Access Forms)
