Ligar a uma BD Access

Solução 1

dim conn, rs
   Set conn = Server.CreateObject("ADODB.Connection")
   conn.open ("PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=O caminho completo para a tua base de dados")
   Set rs = Server.CreateObject("ADODB.Recordset")
   rs.open "Select * from tabela",fp_conn

Solução 2

using System;
using System.Data.OleDb;

public class DAL
   {
      public static string DbName = "basedados.mdb";
      public static string DbPathName;
      private static string StrConn1 = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";
      private static string StrConn;      // StrConn = StrConn1 + DbPathName
      private static OleDbConnection Conn;
      private static OleDbCommand Cmd;
      private static OleDbDataReader DtReader;
      //public static string utilizador;

      public DAL()
      {
         //
         // TODO: Add constructor logic here
         //
      }

      public static void GetConnection()
      {
         if (StrConn == null) StrConn = StrConn1 + DbPathName;
         // Conn= new OleDbConnection(StrConn);
         Conn = new OleDbConnection();
         Conn.ConnectionString= StrConn;
         Conn.Open();
      }

      public static void CloseConnection()
      {
         DtReader.Close();
         Conn.Close();   
      }

      public static OleDbConnection GetObjConn()
      {
         return Conn;
      }
}