Results 1 to 2 of 2

Thread: Recordset

  1. #1
    Kevin Guest

    Default Recordset

    I have an asp page from which I am connecting to 3 tables of one Access Database. Everytime I am executing a SQL statement on one table, i&#039m obliged to write this following command:<BR> strsql, "Driver=Microsoft Access Driver (*.mdb); DBQ= db1.mdb;<BR><BR>is there any other way, because this one is taking too much time<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset

    Open the database connection seperatley<BR><BR>Set Conn=Server.CreateObject("ADODB.Connection")<BR>Se t oRS=Server.CreateObject("ADODB.Recordset")<BR><BR> ConnStr="Driver={Microsoft Access Driver (*.MDB)};DBQ=" & Server.MapPath("db1.mdb")<BR>Conn.Open ConnStr<BR><BR>oRS.Open Sql, Conn, 2, 3<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