---
title: "Connection Strings for MS Access"  
description: "In this article I have described how to establish connection string in your application. Establishing a connection to an Access database in Visual Bas"  
author: "AVADHESH PATEL"  
published: 2013-04-26  
updated: 2017-11-30  
canonical: https://www.mindstick.com/articles/1268/connection-strings-for-ms-access  
category: "ms access"  
tags: ["ms access"]  
reading_time: 1 minute  

---

# Connection Strings for MS Access

In this [article](https://yourviews.mindstick.com/view/81489/kashmir-now-after-an-year-of-abrogation-of-article-370) I have described how to establish [connection string](https://www.mindstick.com/articles/17/connection-string) in [your application](https://answers.mindstick.com/qa/95487/how-do-you-troubleshoot-when-your-application-link-is-not-responding). Establishing a connection to an [Access database](https://www.mindstick.com/forum/385/access-database-datatype-problem) in [Visual](https://www.mindstick.com/articles/327169/major-advantage-to-use-visual-studio-code-in-2019-powerful-ide-used-by-most-of-the-developers) Basic, C# and Java are given below.

##### Visual Basic

```
Public Sub ConnectToAccess()    Dim conn As 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\dbFile.mdb"    Try        conn.Open()        ' Insert code to process data.    Catch ex As Exception        MessageBox.Show("Failed to connect to data source")    Finally        conn.Close()    End TryEnd Sub 
```

##### C#

```
 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();        }    } 
```

##### Java

```
 public void ConnectToAccess()    {        try        {            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");            String database =              "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=myDB.mdb;";            Connection conn = DriverManager.getConnection(database, "", "");            Statement s = conn.createStatement();            conn.close();        }        catch (Exception ex)        {            ex.printStackTrace();        }    }
```

\

---

Original Source: https://www.mindstick.com/articles/1268/connection-strings-for-ms-access

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