Provider cannot be found when opening connection

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

When I try to open connection using below code;

Dim cn As ADODB.Connection
Dim strConnect As String

strConnect = "Provider=Microsoft.Jet.OLEDB.3.6;Data Source=F:\My Folder\My
DB.mdb;User Id=admin;Password=;"

Set cn = New ADODB.Connection
cn.Open strConnect

I get 'Provider cannot be found. It may not be properly installed.' error on
statement cn.Open strConnect. What is the problem and how can I fix it?

Thanks

Regards
 
Hi,

You may want to try a newer version:

Provider=Microsoft.Jet.OLEDB.4.0

If that does not help, <http://www.connectionstrings.com/> is a good
source for information about connection strings. If you still need help,
post back with information about your version of Windows and Access.

Clifford Bass
 
Back
Top