ado connection prob.

[newbiekea]

cnnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\safal_data.mdb;Jet OLEDBatabase Password=" & MyDbPassword & ";"

[Luke K]

If your password is stored in the MyDbPassword variable, then yes, newbiekea post is correct as it is treating it as a string literal, therefore, no matter what you set MyDbPassword to your connection object will be trying to connect with the password "MyDbPassword". If this is the case, follow newbiekea's post.

Also, try and be a little nicer with your posts, we are a friendly community here

[RobDog888]

Also, if you dont have a db password set yet you will get an error. Set the pwd first then do
as previously posted.

[sonofgupta]

cnnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\safal_data.mdb;Jet OLEDBatabase Password=" & MyDbPassword & ";"

i had set password into database but when i apply ur code then a message is appear that "could not found ISAM"
plz suggest me what i do?

[RobDog888]

What version of Access are you running?

[sonofgupta]

What version of Access are you running?

i m using access 2002 version.

[dglienna]

I was going to suggest one from http://www.connectionstrings.com/
but, found one that I use:

Dim cn As New ADODB.Connection 'connection
     Dim rs As New ADODB.Recordset 'recordset
      cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "MyData.mdb;Persist Security Info=False"
      rs.Open "Delete TempTable .* from TempTable ", cn, adOpenKeyset, adLockOptimistic, adCmdText

[RobDog888]

This should be the string you need for passwords.

cnnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\safal_data.mdb;User Id=admin;Password=" & MyDbPassword & ";"

[sonofgupta]

This should be the string you need for passwords.

cnnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\safal_data.mdb;User Id=admin;Password=" & MyDbPassword & ";"

ok,
but where i can declare variable "mydbpassword"
if my password is "num1234"