关于使用OLEDB连接access数据库问题

Question

各位大侠，小弟在连接access数据库的时候就会出现，连接数据库出错，提示数据库被其他用户以独占方式打开，请问怎么解决，谢谢各位大侠。

Answer 1

你是不是把数据库的设计表打开了?把你访问的access关了.

Answer 2

一般都是打开设计视图了，也可能是没有写好异常处理代码，导致出错后资源没有被放掉。可以在资源管理器里关掉ASP.net的进程让它重新启动看看。

Answer 3

重启一下IIS就行了!!每次打开access的时候都要关闭

Answer 4

各位大侠，小弟代码如下：
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;namespace WebApplication2
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
protected System.Data.OleDb.OleDbConnection oleDbConnection1;
protected WebApplication2.DataSet1 dataSet11;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Button Button1;

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{    
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.dataSet11 = new WebApplication2.DataSet1();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
// 
// oleDbDataAdapter1
// 
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "peopleaddress", new System.Data.Common.DataColumnMapping[] {
 new System.Data.Common.DataColumnMapping("address", "address"),
 new System.Data.Common.DataColumnMapping("BP1", "BP1"),
 new System.Data.Common.DataColumnMapping("BP2", "BP2"),
 new System.Data.Common.DataColumnMapping("bron", "bron"),
 new System.Data.Common.DataColumnMapping("email", "email"),
 new System.Data.Common.DataColumnMapping("fax", "fax"),
 new System.Data.Common.DataColumnMapping("homepage", "homepage"),
 new System.Data.Common.DataColumnMapping("id", "id"),
 new System.Data.Common.DataColumnMapping("memo", "memo"),
 new System.Data.Common.DataColumnMapping("name", "name"),
 new System.Data.Common.DataColumnMapping("phone1", "phone1"),
 new System.Data.Common.DataColumnMapping("phone2", "phone2"),
 new System.Data.Common.DataColumnMapping("QQ", "QQ"),
 new System.Data.Common.DataColumnMapping("yb", "yb")})});
// 
// oleDbSelectCommand1
// 
this.oleDbSelectCommand1.CommandText = "SELECT address, BP1, BP2, bron, email, fax, homepage, id, [memo], name, phone1, p" +
"hone2, QQ, yb FROM peopleaddress";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
// 
// oleDbInsertCommand1
// 
this.oleDbInsertCommand1.CommandText = "INSERT INTO peopleaddress(address, BP1, BP2, bron, email, fax, homepage, [memo], " +
"name, phone1, phone2, QQ, yb) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.VarWChar, 50, "address"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("BP1", System.Data.OleDb.OleDbType.VarWChar, 50, "BP1"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("BP2", System.Data.OleDb.OleDbType.VarWChar, 50, "BP2"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("bron", System.Data.OleDb.OleDbType.VarWChar, 50, "bron"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("email", System.Data.OleDb.OleDbType.VarWChar, 50, "email"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("fax", System.Data.OleDb.OleDbType.VarWChar, 50, "fax"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("homepage", System.Data.OleDb.OleDbType.VarWChar, 50, "homepage"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("memo", System.Data.OleDb.OleDbType.VarWChar, 50, "memo"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("name", System.Data.OleDb.OleDbType.VarWChar, 50, "name"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("phone1", System.Data.OleDb.OleDbType.VarWChar, 50, "phone1"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("phone2", System.Data.OleDb.OleDbType.VarWChar, 50, "phone2"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("QQ", System.Data.OleDb.OleDbType.VarWChar, 50, "QQ"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("yb", System.Data.OleDb.OleDbType.VarWChar, 50, "yb"));
// 
// oleDbConnection1
// 
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=0;Data Source=""G:\VB程序\address\address.mdb"";Jet OLEDB:Engine Type=4;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
// 
// dataSet11
// 
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); }
#endregion private void Button1_Click(object sender, System.EventArgs e)
{
oleDbDataAdapter1.Fill(dataSet11);
DataGrid1.DataBind ();
}
}
}