can anyone show me what's should be my connectionString if my data base is access?
Printable View
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 :)
like this: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"
??
Code:sConnString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.mdb;Jet OLEDB:Database Password=secret