Member Avatar for 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

  • 3 Contributors
  • 3 Replies
  • 80 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by guest11
Member Avatar for selvaganapathy

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

Member Avatar for Jx_Man

what kind of error?

Member Avatar for guest11

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

regards
Guest11

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.