password for access 2000

<i><b>Originally posted by : Kaustubh (e-bapu@usa.net)</b></i><br /><br />hello friends <br />i have given password to my access 2000 database<br />now i dont know how to use the password opption in the asp file using dsn-less connection <br />please someone give me the code for the dsn-less connection using password for ms access 2000<br />thanks a lot<br />

<i><b>Originally posted by : Robert (rhod@sympatico.ca)</b></i><br /><br />Hi,<br /><br />try this: (but keep it all on one line)<br /><br />oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:/inetpub/webHostName/folderName/nameOfDatabase.mdb;username=Admin;password=secretp wd"<br /><br />You don't necessarily have to enter a username, just the password<br /><br />Good Luck,<br />Robert<br /><br /><br />------------<br />Kaustubh at 6/13/2001 4:25:21 AM<br /><br /><br />hello friends <br />i have given password to my access 2000 database<br />now i dont know how to use the password opption in the asp file using dsn-less connection <br />please someone give me the code for the dsn-less connection using password for ms access 2000<br />thanks a lot<br />