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