Connection String is fine until...

[PJB]

i password the database, here is the connection string:

Set Conn = Server.CreateObject("ADODB.Connection")
    Set RS = Server.CreateObject("ADODB.RecordSet")   

DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)};" 
    DSNtemp=dsntemp & "DBQ=" & server.mappath("../db/database.mdb")
    conn.Open DSNtemp, 1, 3

can anybody point out where i should be putting the uid and pwd? I've tried just about everywhere in the string

[Kagey]

just put ;pwd=PASSWORD; as in:

Set Conn = Server.CreateObject("ADODB.Connection")
    Set RS = Server.CreateObject("ADODB.RecordSet")   

DSNtemp = "DRIVER={Microsoft Access Driver (*.mdb)};" 
    DSNtemp = DSNtemp & "DBQ=" & server.mappath("../db/database.mdb") & ";pwd=PASSWORD;"
    conn.Open DSNtemp, 1, 3

[PJB]

i put my password in the way you stated and it's still giving me this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x58c Thread 0x674 DBC 0x161500c Jet'.



it's an Access 2000 database and i'm using Windows 2000 pro

[PJB]

thanx anyway, i got it working with a different connection string