ADODB Connection String

N

Nigel C

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.
 

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