I am using Visual Basic 6 and MS Access 2000. I set the database password from Tools -> Security -> Set database password menu in MS Access 2000. Then in visual basic I have added reference of "Microsoft Activex Data Objects Library 2.0". Created a Connection object variable and in the Form load event, set its properties as:
Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\whatever.mdb; Jet OLEDB: Database Password=mypassword;"
Con.Open
When I run the application, it gives me error that "Could not find installable ISAM"
Is there snything wrong with the connection string or what?? Please help. Thanks in advance.