visual basic and ms access

[papaboy2]

ei i have a vb program trying to connect to a password protected access db but i'm getting the error "could not find installable ISAM", any help pls! i'll appreciate, thx!

here's my code

strConnect = "Jet OLEDBatabase Password=password;DataSource=" & App.Path & "\database\DB_GL.mdb;"

Set AdoCn = New Connection
AdoCn.Provider = "microsoft.jet.oledb.4.0"

AdoCn.Open strConnect, "", ""

 

[CCLINT]

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\database\DB_GL.mdb & "Jet OLEDBatabase Password=password"

Set AdoCn = New Connection
AdoCn.Open strConnect

Or:
With AdoCn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("User ID&quot = "Admin"
.Properties("Jet OLEDBatabase Password&quot = "password"
.Open App.Path & "\database\DB_GL.mdb
End With

If this doesn't work then you may have a missing reverence in the registry, to the JET 4.0 OLEDB provider.

 

[baileyhp]

What version of VB are you using? IF it is 6.0 you need to update the service pack. I had this same error on a new XP machine. It worked on the old but not the new. Needed to update service pack.

 

[CCLINT]

Or install MDAC 2.5 to get the JET 4 provider added and/or registered.