.NET Connectivity to Access Database using C sharp

Problem

You want to connect to a Microsoft Access database that has a database password.

Solution

Use the Jet OLEDB:Database Password attribute in the connection string to specify the password.

File: AccessPasswordForm.cs

// Namespaces, variables, and constants

using System;

using System.Configuration;

using System.Text;

using System.Data;

using System.Data.OleDb;

//  . . .

private void connectButton_Click(object sender, System.EventArgs e)

{

    StringBuilder result = new StringBuilder( );

    // Build the connections string incorporating the password.

    String connectionString =

        ConfigurationSettings.AppSettings["MsAccess_Secure_ConnectString"]+

        "Jet OLEDB:Database Password=" + passwordTextBox.Text + ";";

    result.Append("ConnectionString: " + Environment.NewLine +

        connectionString + Environment.NewLine + Environment.NewLine);

    OleDbConnection conn = new OleDbConnection(connectionString);

    try

    {

        conn.Open( );

}