Contact Info

Crumbtrail » Administration » Scripts » VBScript » Custom script

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.


  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)


  Set RS = Nothing

  Set objConn = Nothing