---
title: "How to connect access database in c#"  
description: "How to connect access database in c#"  
author: "Dag Hammarskjold"  
published: 2013-06-19  
updated: 2013-07-25  
canonical: https://www.mindstick.com/forum/1204/how-to-connect-access-database-in-c-sharp  
category: "ado.net"  
tags: ["ado.net"]  
reading_time: 2 minutes  

---

# How to connect access database in c#

Hi [Developers](https://www.mindstick.com/articles/12875/blunders-you-must-avoid-while-hiring-java-developers-to-get-the-best-fulfilling-your-needs),\
\
I have [access database](https://www.mindstick.com/forum/385/access-database-datatype-problem) [file](https://www.mindstick.com/articles/59/encrypting-and-decrypting-files-using-c-sharp) with 7 [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) in it but I don't know how to [connect](https://www.mindstick.com/articles/12810/how-to-connect-tablet-to-external-monitor-or-flat-screen-tv-using-computer-adapters) and show all tables, If some one can help me?\
\
this is my [code](https://yourviews.mindstick.com/view/85458/alan-turing-the-mastermind-behind-cracking-the-enigma-code-during-world-war-ii) but it doesn't show anything\
\

```
private void button1_Click(object sender, EventArgs e){    OleDbConnection conn = new OleDbConnection();    String connection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\Tables.accdb;Persist Security Info=True";    string sql  = "SELECT Clients  FROM Tables";    conn.ConnectionString = connection;    conn.Open();    DataSet ds = new DataSet();    DataGridView dataGridView1 = new DataGridView();    BindingSource bSource = new BindingSource();    OleDbDataAdapter adapter = new OleDbDataAdapter(sql,conn);    adapter.Fill(ds);    //conn.Close();                                   dataGridView1.DataSource = ds;
```

\
Your help is greatly appreciated.

## Replies

### Reply by Manmohan Jha

Using MS [Access](https://www.mindstick.com/articles/12994/how-foreigners-can-access-blocked-websites-in-china) 2007\
My [database file](https://www.mindstick.com/forum/159377/how-to-add-edit-retrieve-data-using-local-database-file-in-microsoft-visual-studio-2012) in:- MyProject/bin/Debug\

```
           private void btnSave_Click(object sender, EventArgs e)           {            OleDbConnection con = new OleDbConnection();            con.ConnectionString =@"provider= Microsoft.ACE.OLEDb.12.0; Data Source =" + Application.StartupPath + "\\Db_School.accdb; Jet OLEDB:Database Password=Password";            con.Open();            OleDbCommand cmd = new OleDbCommand("SELECT Clients  FROM Tables", con);            DataGridView dataGridView1 = new DataGridView();            DataTable dt = new DataTable();            OleDbDataReader dr = cmd.ExecuteReader();            dt.Load(dr);            con.Close();                                           dataGridView1.DataSource = dt;           }
```

Mj

### Reply by Anonymous User

Hi,\
Try this code,\

```
public void ConnectToAccess(){    System.Data.OleDb.OleDbConnection conn = new         System.Data.OleDb.OleDbConnection();    // TODO: Modify the connection string and include any    // additional required properties for your database.    conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +        @"Data source= C:\Documents and Settings\username\" +        @"My Documents\AccessFile.mdb";    try    {        conn.Open();        // Insert code to process data.    }        catch (Exception ex)    {        MessageBox.Show("Failed to connect to data source");    }    finally    {        conn.Close();    }}
```

**\**I hope it helpful for you.


---

Original Source: https://www.mindstick.com/forum/1204/how-to-connect-access-database-in-c-sharp

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.