Can someone please help me. I'm writing a VB5 app that connects to an Access 97 database using a data access control with the following parameters:
Connect = "Access"
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
(The app sets the DatabaseName and RecordSource properties at runtime.)
When the database doesn't have a password, it works perfectly. But when I give it a password ("OpenSesame") and change the Connect string to "Access;pwd=OpenSesame", I get this error:
"Couldn't find installable ISAM."
I need to solve this so that my database can be password-protected. Any ideas?
I will also need to connect to the database from Crystal Reports, but first things first!