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