Open password protected database

[Navel12]

Hello,

I have a VB6 SP5 application which has a bound data control field. I want to pasword protect an Access 2000 database. I would like to use the connect property to supply a password. My connect property field looks like:

Access 2000;pwd=<password>;

When I run the application I get "Could not find installable ISAM."

Thanks for your help!!!

 

[jebenson]

Try updating MDAC to the latest version (2.8). You can get it at this link:

[URL unfurl="true"]http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDAC[/url]

Be sure to download and apply the MDAC security update on this page as well.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[Dimandja]

Most likely, your connection string is not good.

For example, instead of "PWD", use "Password". And, what's the "Access 2000" bit doing there?

ISAM drivers are used by Access to update non-Access file formats. If the Registry is invalid or the Isam driver does not exist, you could get that same error message.

Try fixing your connection string. Try something like:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\<access db name>.mdb;
Jet OLEDB:Engine Type=5;
Jet OLEDB:Database Password=<password>

 

[Swi]

Try one of these links to see if you have your connection string correct:

http://www.connectionstrings.com/

or

http://www.able-consulting.com/ADO_Conn.htm

Swi