ado connection prob.

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