how to access password secure database?

[guest11]

hi all,

I am facing small problem in access database .
I am using MS-Access database in our application and i secure it by setting password to my database. But now i want to acces that database through coding in my vb application but it is generating error. So can anybody tell me how to access database which is secured by password.

I write code for that as follows:
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=true;Password=myDatabasePassword;Data Source=" & myDatabasePath

But when i run my application it is generating error.
So can anybody give me proper line of code for accessing ms-access database.

Thanks in advance
Guest11

[selvaganapathy]

Hi, Use
ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=MyDB;Persist Security Info=true;Jet OLEDB:Database Password=MyPassword"

[Jx_Man]

what kind of error?

[guest11]

thank you very much selvaganapathy for ur rly my problem is solved .

regards
Guest11