I have a form where user enters user name and then I want to open the database corresponding to the user name.
I am writing the following code :
<%
   Dim objConn, objRS, strQuery,objDC,strConnection,uid,strPath
 uid=Request.form("uid")
Set objConn = Server.CreateObject("ADODB.Connection")
strPath= "\" & "& uid &" & ".mdb;"
strConnection= "Driver={Microsoft Access Driver (*.mdb)};" & _
              "Dbq=" & Server.MapPath(".") & strPath
objConn.Open strConnection

strQuery = "SELECT research_interest from tblresearch"

Set objRS = objConn.Execute (strQuery)

%>

I am getting thr follwing error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x22c Thread 0x4b8 DBC 0x2077fc4 Jet'.
PLEASE HELP!!

Hi there,

You pass uid as a string, not as the value of a variable:

strPath= "\" & "& uid &" & ".mdb;"

should be:

strPath= "\" & uid & ".mdb;"

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.