ado could not find the specified provider

that's the error im receiving here is my code:

Set mCN = New Connection

With mCN
.ConnectionString = "Provider=Microsoft.jet.oledb.4.00;datasource='c:\my documents\people.mdb'"
.CursorLocation = adUseClient
.Open


does anyone have an ideas what the problem could be; i would appreciate any help.

i have mdac 2.1 installed

Use OLE DB provider 3.51
I've had this problem.. installed on a clean machine provider 4.0 is installed, but a machine where Office 97 already was installed had provider 3.51 installed, and my installation didn't install 4.0 :-(
I have an error handling like
On Error Resume Next
' open connection with provider 4.0
If Err.Number <> 0 then
' if that failed, try it withh provider 3.51
End if

now im getting:

"couldn't find installable isam" with both 3.51 and 4.00 when i call them through code

help

When you specify the OEDB provider for 4.0, you have extra 0 (zero) there.

Should be something like this:

Code:

---

cn.Provider = "Microsoft.Jet.OLEDB.4.0"
cn.Open "C:\MyDB.mdb", "admin", ""

---