connectionString to MS-Access

[Cerebrate]

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

[peet]

something like this

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

[Cerebrate]

Do i have to register my database on ODBC?

[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"
??

[peet]

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

[peet]

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:

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