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.

All you need to know, you can get from here -
http://www.connectionstrings.com/

The specific example listed there for your case is...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDBatabase Password=MyDbPassword;"

Note that a database password is something distinct and different from a user
name and password used with workgroup security. A database password is never
supplied using the password argument.


On 19 Aug 2005 23:30:12 -0700, "Nigel C" <nigelpcorrigan (AT) hotmail (DOT) com> wrote: