Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADODB Connection String
Access 2000 - A am trying to access another Access 2000 database from a
code module. I have seen examples of the ADODB connection string - to connect to an access database however the database that I am connecting to has a database password - I get an error message when attempting to specify the 'connect' parameter. The following is an example... Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim strSQL As String Set cnn = New ADODB.Connection cnn.Provider = "Microsoft.Jet.OLEDB.4" cnn.Open "C:\Schedule Analysis.mdb", "Admin", "MadeUpPassword" However the open statement throws up the following error... Error Number - "3706" Description - "Provider cannot be found. It may not be properly installed." Any thoughts on what is wrong here? Many Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADODB Connection String
SORRY please ignore this - posted to wrong group !
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADODB Connection | Excel Worksheet Functions | |||
share adodb connection in excel | Excel Programming | |||
Virus - importing excel via adodb connection | Excel Programming | |||
ADODB Connection to Access | Excel Programming | |||
Can't get connection string right | Excel Programming |