Database password

<i><b>Originally posted by : Simon Pocklington (ca8spo@isis.sund.ac.uk)</b></i><br />I'm trying to open a database secured by a password with an ASP page<br /><br />The database, without a password, opens with the code shown below:<br /><br />'Create a connection object<br />Set Conn = Server.CreateObject("ADODB.Connection")<br /><br />'Select provider<br />Conn.Provider = "Microsoft.Jet.OLEDB.4.0"<br /><br />'Select data source - the Kingswood database.<br />Conn.ConnectionString = "Data Source=" & Server.MapPath ("kingswood.mdb")<br /><br />'Open the connection<br />Conn.Open<br /><br />How do I modify this code to open the database when it has a password?

<i><b>Originally posted by : Ingrid (ihei@moeridjk.nl)</b></i><br />You can use this code:<br />Conn.Open "ASPcursus", "username", "password"<br /><br />------------<br />Simon Pocklington at 4/2/2001 7:12:39 AM<br /><br />I'm trying to open a database secured by a password with an ASP page<br /><br />The database, without a password, opens with the code shown below:<br /><br />'Create a connection object<br />Set Conn = Server.CreateObject("ADODB.Connection")<br /><br />'Select provider<br />Conn.Provider = "Microsoft.Jet.OLEDB.4.0"<br /><br />'Select data source - the Kingswood database.<br />Conn.ConnectionString = "Data Source=" & Server.MapPath ("kingswood.mdb")<br /><br />'Open the connection<br />Conn.Open<br /><br />How do I modify this code to open the database when it has a password?