I have a VB6(SP4) application that runs fine under Mdac 2.5 using a Jet 3.51
ADO connection. When I switch to a Jet 4.0 conection, I get an 'open_method
failed' message when I try to open a recordset that has inner joins. Simple
'opens' seem to work fine. Any help on what I must do to get this an app to
run under Jet 4.0 will be greatly appreciated.
*** This connection works fine ***
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security
Info=False;Data Source = " & App.Path & "\" & sDBName
When I change 3.51 to 4.0 I have the problem mentioned above.
Thanks, Craig
MS Jet 3.51 vs Jet 4.0