VB5 app can't connect to a password-protected Access 97 database

Hi all,

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!

Hi people,

No one has replied to my post. Just wondering if anyone has some ideas on how I can get my VB app to connect to a password-protected Access database. Please help, I'm desperate!

Greg.