connectionString to MS-Access

can anyone show me what's should be my connectionString if my data base is access?

something like this

Code:

---

sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb"

---

Do i have to register my database on ODBC?

the database requires password.
so do i just add this:
sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;password=xxxx"
??

good link : http://www.able-consulting.com/ADO_Conn.htm :)

Quote:

---

Originally posted by Cerebrate
the database requires password.
so do i just add this:
sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;password=xxxx"
??

---

like this:

Code:

---

sConnString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.mdb;Jet OLEDB:Database Password=secret

---