Provider cannot be found when opening connection

[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

 

[Clifford Bass]

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