How to Add or Change the Password on a Microsoft Access Database File Using C#

Code snippet for adding or changing the password on a Microsoft Access database file:

using System.Data.OleDb;

string fileName = "YourDatabaseFilename";

string newPassword = "ThisIsTheNewPassword";

string oldPassword = null;
string connectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + fileName +
                                           ".accdb; Jet OLEDB:Database Password =" + oldpassword + "; Mode=12";

OleDbConnection con = new OleDbConnection(connectionString);

string query = string.Format("ALTER DATABASE PASSWORD [{0}] [{1}]", newPassword, oldPassword);

OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Pages you may also want to visit:

Adding a Table on a Microsoft Access Database File

Creating a Microsoft Access Database File