By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,718 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,718 IT Pros & Developers. It's quick & easy.

ADODB Connection String with password

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
OLEDB:Database 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" <ni************@hotmail.com> wrote:
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.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.