Connect to an Access database file

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

class AccessConnect {
   static void Main() 
   {
      string connString = @"provider = microsoft.jet.oledb.4.0;data source = Employee.mdb;";

      OleDbConnection conn = new OleDbConnection(connString);

      try 
      {
         conn.Open();
         Console.WriteLine("Connection opened.");

         Console.WriteLine("Connection Properties:");   
         Console.WriteLine("\tConnection String: {0}", conn.ConnectionString);    
         Console.WriteLine("\tDatabase: {0}",conn.Database);   
         Console.WriteLine("\tDataSource: {0}",conn.DataSource);
         Console.WriteLine("\tServerVersion: {0}", conn.ServerVersion);
         Console.WriteLine("\tState: {0}", conn.State);
      } catch (OleDbException e) {
         Console.WriteLine("Error: " + e);  
      } finally  {
         conn.Close();
         Console.WriteLine("Connection closed.");
      }
   }
}

Related examples in the same category

1.	Connects to a Microsoft Access database
2.	Reading Access Data
3.	How to use an OleDbConnection object to connect to an Access database
4.	Use OdbcCommand to read data in Access database and fill the DataGrid
5.	Read query result data from Access database

Connect to an Access database file : Access « Database ADO.net « C# / C Sharp

Related examples in the same category