connecting to access database with password

[firozfasilan]

pCnString = "Data Source=" & App.Path & "\database\WO.m db;Provider=Mic rosoft.jet.oled b.4.0; uID=sa;Pwd=subh analla"


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.m db;Provider=Mic rosoft.jet.oled b.4.0; uID=sa;Pwd=subh analla"


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.microso ft.com/kb/209805

thanks
ansuman

[rajaaryan44]

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

use this u can set the connection.

[vijaydiwakar]

Good reply Rajaaryan44