C#连接带密码的Access 2007数据库

using System.Data.OleDb;  //引入命名空间

//数据库连接字符串
        String strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;
                       Data Source=.\WuBiDb.accdb;
                       Jet OLEDB:Database Password=123456";

//连接数据库变量
private OleDbConnection dbConn = null;

 //连接数据库方法
        public void ConnDb(String strConn)
        {
            using (dbConn= new OleDbConnection(strConn))
            {
                try
                {
                   dbConn.Open();
                   MessageBox.Show("连接数据库Success!" );
                }
                catch (Exception ex)
                {
                    MessageBox.Show("连接数据库失败:"+ex.Message);
                }
                // The connection is automatically closed when the
                // code exits the using block.
            }
        }

 

 

 

 

转载于:https://www.cnblogs.com/friendan/archive/2012/11/17/2774826.html