2 Replies - 6000 Views - Last Post: 14 September 2009 - 07:29 AM Rate Topic: -----

#1 fschino  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 13
  • Joined: 26-August 09

How to open an password protected ms access database?

Post icon  Posted 08 September 2009 - 06:30 PM

i am using ms access 2003 as my database in vb.net,i want to secure it with a password. what should i add to my code to open my DB?

	Public con As New OleDb.OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=C:\jada\Database\jadaDB.mdb")



thanks!
Is This A Good Question/Topic? 0
  • +

Replies To: How to open an password protected ms access database?

#2 PDUNZ  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 43
  • View blog
  • Posts: 376
  • Joined: 17-July 09

Re: How to open an password protected ms access database?

Posted 09 September 2009 - 02:57 AM

By using Password=yourpassword to your connection string.

This post has been edited by PDUNZ: 09 September 2009 - 02:57 AM

Was This Post Helpful? 0
  • +
  • -

#3 fschino  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 13
  • Joined: 26-August 09

Re: How to open an password protected ms access database?

Posted 14 September 2009 - 07:29 AM

View PostPDUNZ, on 9 Sep, 2009 - 01:57 AM, said:

By using Password=yourpassword to your connection string.



hi pdunz
i try what you've been told


Public con As New OleDb.OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=C:\jada\Database\jadaDB.mdb;Password=password;")

but if i open ms access it says that i need to open my db as external open. how can i do that. i already did my best but i cant find it.

please help :D
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1