could not find installable ISAM

[Guest]

I try to connect to my Access db using the following code:
Dim connectString As String
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"DataSource = C:\Access\db1.mdb"


Dim myDB As ADODB.Connection
Set myDB = New ADODB.Connection
myDB.Open connectString
------------------
when I run the code, it pops up the error message, "Could not find
installable ISAM"
Can you tell me why?
Thank you, Curie
P.S. I already create the DSN for the database

 

[David Lloyd]

Curie:

Try the connection string with the word DataSource as two words. For
example:

connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = C:\Access\db1.mdb"

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I try to connect to my Access db using the following code:
Dim connectString As String
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"DataSource = C:\Access\db1.mdb"


Dim myDB As ADODB.Connection
Set myDB = New ADODB.Connection
myDB.Open connectString
------------------
when I run the code, it pops up the error message, "Could not find
installable ISAM"
Can you tell me why?
Thank you, Curie
P.S. I already create the DSN for the database

 

[Guest]

You are right, David. It's OK now.
Thanks a lot!
Curie