Cannot find installable ISAM

[mesh2005 via AccessMonster.com]

I use VB 6, JET engine to connect to an Access database
I'm trying to set the connection string of the data environment connection st
runtime as follows:
DataEnvironment1.Connection1.ConnectionString = "Microsoft.Jet.OLEDB.4.
0;Data Source=" & "mydb.mdb" & ";Persist Security Info=False"
DataEnvironment1.Connection1.Open

but I get this error "Cannot find installable ISAM"

I hope you can help!

Thanks!

 

[Brendan Reynolds]

You're missing the 'Provider=' in front of 'Microsoft'. You'll probably also
need the full path and name of the MDB rather than just the name.

DataEnvironment1.Connection1.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4 0;Data Source=" & "c:\somefolder\mydb.mdb" &
";Persist Security Info=False"