When I am trying to connect to a MS Access database to display a data report, I am getting a dialog-box pop-up showing the different parameters for the connection string. Clicking on either the 'OK' or 'Cancel' buttons gives a "Couldn't find Installable ISAM" error.
The database is not password protected. Other projects in the same machine, which uses the same code for connecting (except the filename), are working perfectly.
Why am I getting the pop-up and the error ? Searching through MSDN & KB articles suggested some incompatible MSVBVM60.dll problems. But in that case, none of the other projects should be running also.
Here's the Code for connection:
If DEnv.Conn.State = adStateOpen Then DEnv.Conn.Close End If DEnv.Conn.ConnectionString = "Provider=MSDataShape.1;" & _ "Persist Security Info=False;" & _ "Data Source=" & mFileName & ";" & _ "Data Provider=Microsoft.Jet.OLEDB.4.0" DEnv.Conn.Open
The error is occurring at the DEnv.Conn.Open line