connecting to access database with password

[firozfasilan]

pCnString = "Data Source=" & App.Path & "\database\WO.mdb;Provider=Microsoft.jet.oledb.4.0 ; uID=sa;Pwd=subhanalla"


i am used the above code for providing a password to access database
when i am try to open it , it gives a error message and i can't open the access data base .
please help me

the error is "could not find the installable ISAM"

[ansumansahu]

pCnString = "Data Source=" & App.Path & "\database\WO.mdb;Provider=Microsoft.jet.oledb.4.0 ; uID=sa;Pwd=subhanalla"


i am used the above code for providing a password to access database
when i am try to open it , it gives a error message and i can't open the access data base .
please help me

the error is "could not find the installable ISAM"

Hi ,

Look at this link. Microsoft gives a resolution for the above problem.

http://support.microsoft.com/kb/209805

thanks
ansuman

[rajaaryan44]

Dim cnn As ADODB.Connection
Private Sub OpenConnection()
Dim strCnn As String
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\WareHouse_Maint.mdb;Persist Security Info=False;Jet OLEDB:Database Password= raju"
' connection string
Set cnn = New ADODB.Connection
cnn.Open strCnn
End Sub

use this u can set the connection.

[vijaydiwakar]

Good reply Rajaaryan44