-
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", ""