VBScript Code to Open and close connection MS Access Database

You can use any of the VBScript programs below in ActiveXperts Network Monitor. Click here for an explanation about how to include scripts in ActiveXperts Network Monitor.

Example(s)

  Set objConn = Server.CreateObject("ADODB.Connection")
  strDbPath = "C:\test.mdb"
  objConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & strDbPath & ";"

  strSqlQuery = "SELECT * FROM table"
  Set RS = objConn.Execute(strSqlQuery)

  

  RS.Close
  Set RS = Nothing

  objConn.Close
  Set objConn = Nothing