Problems Connecting to Access Database

Results 1 to 2 of 2

Thread: Problems Connecting to Access Database

  1. #1
    Join Date
    Dec 1969

    Default Problems Connecting to Access Database

    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>

  2. #2
    jimmy w Guest

    Default RE: Problems Connecting to Access Database

    try this:<BR>ConnectionString="DRIVER={Microsoft Acess Driver (*.mdb)};" & "DBQ=d:abcUpdate5.mdb"<BR><BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .Open ConnectionString<BR><BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts