ado connection prob.

[sonofgupta]

hi
when i m connect a database using ado code.
i m getting an error message "not a valid password"
code is
dim cnnstr as string
cnnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\safal_data.mdb;Jet OLEDBatabase Password=MyDbPassword;"
plz solve my prob immidietly.

[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"

[RobDog888]

Depends on how you want it to work.

If your ok with hardcoding it into your app then you dont even need to use the variable, just code it where the var is.

If you want to be able to change it without re-compiling then you can either store it in a file or the registry,
encrypted or not. Its up to you.