ASP Source Code: 
<%
   DIM ADOcn,ADOrs
   set ADOcn=Server.CreateObject("ADODB.Connection")

' Use the following for a System DSN connection 
  ADOcn.Open  "dsnNwind" ' the DSN must already be 'pointing to the .MDB'

' The following two lines are for DSN-less connection
'   ADOcn.Provider="Microsoft.Jet.OLEDB.4.0"
'   ADOcn.Open  "c:/webdata/Nwind.mdb"

   set ADOrs = Server.CreateObject("ADODB.recordset")
%>