I have upload an Access2000 Database onto a webserver which is hosted by a company. My intention is to use the database to verify whether a particular user is allowed to login to a section for registered users only by calling an asp page to do so.<BR><BR>I try to connect to my Access database using the codes below:<BR> <BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.ConnectionString="DRIVER={Microsoft Acess Driver (*.mdb)};" & "DBQ=d:abcUpdate5.mdb"<BR> <BR> <BR> Dim objRS<BR> Set objRS = Server.CreateObject("ADODB.Recordset")<BR> objRS.Open "UpgradePack", objConn, , , adCmdTable<BR> <BR>However, I am unable to connect to the database. I have the following errors:<BR><BR>ADODB.Recordset error &#039 800a0e7d&#039 <BR><BR>Operation is not allowed on an object referencing a closed or invalid connection. <BR><BR>/result.asp, line 20 <BR><BR>Can anyone tell me what has gone wrong with my coding?<BR><BR>Thanks in advance!<BR>Regards <BR>Jen<BR>