** Problem Updating MS Access DB **

[binayak]

Hi

I'm trying to update a MS Access Database from my ASP.NET Application. I keep getting this error:


Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.

I think it's because the .mdb file doesn't have write access. I'm using a Windows XP Pro machine, I want to know how set proper write access for the .mdb file for the ASPNET account.


Here is the code for reference:

DataSet ds;
OleDbDataAdapter  adpt;
OleDbConnection conn = null;

private void Page_Load(object sender, System.EventArgs e)
{
	conn = new OleDbConnection(
		"Provider=Microsoft.Jet.OLEDB.4.0; " +
		"User ID=Admin;" +
		"Data Source=" + @"C:\Pets\Pets.mdb");
	adpt = 
		new  OleDbDataAdapter("Select * FROM PetType", conn);
	ds = new DataSet();
	adpt.Fill (ds , "table");
	datagrid.DataSource = ds;
}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

private void Button1_Click(object sender, System.EventArgs e)
{
	OleDbCommand cmdInsert = conn.CreateCommand();
	cmdInsert.CommandType = CommandType.Text;
	cmdInsert.CommandText = "insert into PetType values (@Id," +
		" @PetName, @PetType)";
	cmdInsert.Parameters.Add("@Id",	OleDbType.VarChar, 11);
	cmdInsert.Parameters["@Id"].Value = 3;
	cmdInsert.Parameters.Add("@PetName",OleDbType.VarChar, 20);
	cmdInsert.Parameters["@PetName"].Value = "asas";
	cmdInsert.Parameters.Add("@PetType",OleDbType.VarChar, 20);
	cmdInsert.Parameters["@PetType"].Value = "bat";
	cmdInsert.Parameters["@Id"].SourceVersion = DataRowVersion.Original;
	adpt.InsertCommand = cmdInsert;



	DataRow dr = ds.Tables[0].NewRow();
	dr[0] = 3;
	dr[1]="asas";
	dr[2] ="dwsfsa";
	ds.Tables[0].Rows.Add(dr);
	datagrid.DataBind();

	adpt.Update(ds, "table");

}

Please Help