Connecting Using Access

[sameera]

Hi all,

I have a little address book programe which is written using vb.net. I want to connect it to an Access database through OleDB , or SqlClient. Below are the requirments,

My Access Database should have to have a password
(I tried it without a pasword and working perfectly but with password it fails)
Ex : database - textDB.mdb
Password - testPW

Can anyone help me to overcome this !!!!!!

And nother thing is that please tell me whether i can access my Database through a DSN because then i can use one database to the network

I'll be greatful if you ppl can send me a little code segment

regards,

sameera

 

[ayozzhero]

I think this website should help:
http://www.connectionstrings.com/

Click on Access, then OleDB. It will show you 3 options of string connection to connect to Access.

 

[nakracreative]

database - textDB.mdb
Password - testPW

your connection string should look like ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=<type path of your database here>; userid=<type userid here>; password=testPW; Persist Security Info=false")

 

[sameera]

Thankx

Thankx buddy !

I'll check that out and let you know

anyway thankx a lot

regards,

sameera