1、找不到可安装的 isam

 2、无法启动应用程序。工作组信息文件丢失，或是已被其他用户以独占方式打开

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace DataBase练习 {
   public partial class frmConnectAccess : Form     {
   public frmConnectAccess()         {
               InitializeComponent();         } /// 
 /// 连接数据源 /// 
 /// 用户名 /// 密码 /// 
     
      是否连接成功
              private bool GetConnAccess(string UserName, string PassWord)         {
   bool boo = false; try             {
   string strPath = Application.StartupPath + @"\Access.mdb"; string connStr = "Provider = Microsoft.Jet.OLEDB.4.0;Persist Security Info=true;Jet OLEDB:Database Password = '" + PassWord + "';User ID = " + UserName + ";Data Source = " + strPath;                 OleDbConnection oleCon = new OleDbConnection(connStr);                 OleDbDataAdapter oleDap = new OleDbDataAdapter("select * from 帐目", oleCon);                 DataSet oleSet = new DataSet();                 oleDap.Fill(oleSet, "帐目");                 gridAccess.DataSource = oleSet.Tables[0].DefaultView;                 oleCon.Close();                 oleCon.Dispose();                 boo = true;             } catch (Exception ex)             {
                   MessageBox.Show(ex.Message);             } return boo;         } private void btnConnect_Click(object sender, EventArgs e)         {
   string UserName = txtUserName.Text.Trim(); string PassWord = txtPassWord.Text.Trim(); bool boo = GetConnAccess(UserName, PassWord);         }     } }

 

 

错误连接字符串：string connStr = "Provider = Microsoft.Jet.OLEDB.4.0;DataBase PassWord = '"+PassWord+"';User ID = "+UserName+";Data Source = " + strPath;

DataBase PassWord 应写成 Jet OLEDB:Database Password 注意加：Persist Security Info=true;

正确连接字符串：string connStr = "Provider = Microsoft.Jet.OLEDB.4.0;Persist Security Info=true;Jet OLEDB:Database Password = '" + PassWord + "';User ID = " + UserName + ";Data Source = " + strPath;