open a database depending on session id
Users log in to my system using their id and I have a session variable called Session("id") that stores the username.
Users have research interests, publications and courses they teach.
I want to open a specific user database depending on who logged on as user. Say, user "xyz" logged in , they I want to open "xyz" database.
How should the following asp code be modified so that name of database , in this case "xyz" chenges to "ymx" when user "ymx" logs in?
Set objConn = Server.CreateObject("ADODB.Connection")
strConnection= "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Server.MapPath(".") & "\xyz.mdb;"
I gues i have to concatenate the seesion id with the path . How can I do that ? please help!!
|
