C#修改ACCESS数据库密码

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

namespace ALTERDATABASEPASSWORD

{

public partial class FrmMain : Form

{

public FrmMain()

{

InitializeComponent();

}

private void butAlterd_Click(object sender, EventArgs e)

{

//提示：参数 mode=12为独占模式

string sConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +

"Data Source=" + Application.StartupPath + @"/HYBase.mdb;mode=12;" +

"Persist Security Info=False;" +

"Jet OLEDB:Database Password=123";

System .Console .Write(sConn);

OleDbConnection MyConnection = new OleDbConnection(sConn);

if (MyConnection.State != ConnectionState.Open)

{

try

{

MyConnection.Open(); //打开数据库连接

}

catch (Exception Ex)

{

MessageBox.Show(Ex.Message);

return;

}

}

//"ALTER DATABASE PASSWORD 新密码 旧密码 " null 值 为空密码

string sCmd = "ALTER DATABASE PASSWORD 456 123 ";

OleDbCommand MyCommand = new OleDbCommand(sCmd, MyConnection);

try

{

MyCommand.ExecuteNonQuery();

MessageBox.Show("OK");

}

catch (Exception Ex)

{

MessageBox.Show(Ex.Message);

}

finally

{

MyConnection.Close();

MyCommand.Dispose();

}

}

private void button1_Click(object sender, EventArgs e)

{

//提示：参数 mode=12为独占模式

string sConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +

"Data Source=" + Application.StartupPath + @"/SysInfoDB.mdb;mode=12;" +

"Persist Security Info=False;" +

"Jet OLEDB:Database Password=duan";

System.Console.Write(sConn);

OleDbConnection MyConnection = new OleDbConnection(sConn);

if (MyConnection.State != ConnectionState.Open)

{

try

{

MyConnection.Open(); //打开数据库连接

}

catch (Exception Ex)

{

MessageBox.Show(Ex.Message);

return;

}

}

//"ALTER DATABASE PASSWORD 新密码 旧密码 " null 值 为空密码

string sCmd = "ALTER DATABASE PASSWORD 456 123 ";

OleDbCommand MyCommand = new OleDbCommand(sCmd, MyConnection);

try

{

MyCommand.ExecuteNonQuery();

MessageBox.Show("OK");

}

catch (Exception Ex)

{

MessageBox.Show(Ex.Message);

}

finally

{

MyConnection.Close();

MyCommand.Dispose();

}

}

}

}

         作者：段利庆（Lee）  QQ：14035344