{filelink=16144}

using System;
using System.Data;
using System.Data.OleDb;

   class ConnexionOleDb
   {
      static void Main()
      {
         OleDbConnection ConnexionAccess = new OleDbConnection(@"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=.Clients.mdb");

         OleDbCommand CommandeAccess = new OleDbCommand("SELECT ID, Société FROM Clients",ConnexionAccess);

         try
         {
            ConnexionAccess.Open();
            OleDbDataReader ReaderData = CommandeAccess.ExecuteReader();

            while (ReaderData.Read()) {
               Console.WriteLine("ID et Société: {0} {1}",
                  ReaderData.GetValue(0),
                  ReaderData.GetValue(1));
            }
         }
         catch (OleDbException ex)
         {
		 // En cas d'erreur
            Console.WriteLine(ex.ToString());
         }
         finally
         {
            ConnexionAccess.Close();
            Console.WriteLine("La Connexion a été fermée");
         }
      }
   }