0

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

3
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by guest11
0

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

0

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

regards
Guest11

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.