Results 1 to 2 of 2

Thread: Ter

  1. #1
    Join Date
    Dec 1969

    Default Ter

    I use the code below to connect to access database, however it takes a long time for the connection can anyone tell me is there a faster connection to the database.<BR><BR>Dim objDC, objRS<BR><BR>Set objDC = Server.CreateObject("ADODB.Connection")<BR><BR>obj DC.Open "DBQ=" & Server.MapPath("db_scratch.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Ter

    You might try reversing the code like<BR>Dim objDC, objconn, objRS<BR><BR>Set objDC = Server.CreateObject("ADODB.Connection")<BR><BR>obj conn="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db_scratch.mdb")<BR>objDC.Open objconn

Posting Permissions

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