Website to Database ADO Connectivity Tools
Microsoft Activex Data Object - ADO Connection Examples

Using the OLE DB Provider for Microsoft Access on a Remote Computer

This examples show the method for the OLE DB Microsoft Access on a remote database:

Dim conn as ADODB.Connection
Dim rst as ADODB.Recordset
Dim sql as string
'---------------

Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & _
                   "Server=remote_website; & _
                   DBQ=" & Server.MapPath("remote_database")

remote_website = the url to the website where the remote database exists, such as http://www.blueclaw-db.com

remote_database = the name of the database located on the remote computer, such as Customers.mdb

'--------------  here we use the connection

sql = "select sales_rep, dollars from sales_by_rep_chart"

Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open sql, conn, 3, 3
Set Session("mysession") = rst
rst.movefirst
response.write rst!sales_rep

'--------------

Where mysession is any name for the session.

When done with the recordset don't forget to close it:

Conn.close
set conn=nothing