ACCESS开发中不能保存数据的问题，请教

[canxing2004]

我的采用ADO.NET 修改CCESS数据库后，数据无法保存，或者说每次打开数据库后发现恢复到之前的原始状态，对数据库的修改只是在当时有用。我查阅了许多文章，都说是.ldb文件锁定的问题，本人不是很懂，希望大家知道！谢谢！
我的代码：

public void addSoilBasicInfo()
{
//插入样点
string InsertConnectStr = "INSERT INTO SoilBasicInfo VALUES(" +
"'" + textBox1.Text + "'," +
"'" + textBox10.Text + "'," +
"'" + textBox11.Text + "'," +
"'" + textBox12.Text + "'," +
"'" + textBox13.Text + "'," +
"'" + textBox14.Text + "'," +
"'" + comboBox7.Text + "'," +
"'" + comboBox8.Text + "'," +
"'" + comboBox11.Text + "'," +
"'" + textBox19.Text + "'," +
"'" + comboBox6.Text + "'," +
"'" + textBox20.Text + "'," +
"'" + textBox24.Text + "'," +
"'" + textBox23.Text + "'," +
"'" + textBox22.Text + "')";

//连接数据库
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConn += "Data Source=";
strConn += "PFS1.0.mdb";


myConnection = new OleDbConnection(strConn);
OleDbCommand myCommand = new OleDbCommand(InsertConnectStr, myConnection);

try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
MessageBox.Show("数据添加成功!");
}
catch (OleDbException e)
{
MessageBox.Show("数据错误" + e.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
myConnection.Close();
}
}

[十豆三]

是不是数据库只读了。

[canxing2004]

不是啊，我进ACCESS可以修改数据库的，但是一运行系统就恢复到以前了

[OracleRoob]

压缩修复一下数据库，或者新建MDB，将原来MDB的所有对象导入到新MDB中试一下。

[wwwwb]

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\temp\123.mdb;Jet OLEDB:Database Locking Mode=1";

[changechange]

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConn += "Data Source=";
strConn += "PFS1.0.mdb";
strConn += "Jet OLEDB:Database Locking Mode=1";

[changechange]

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConn += "Data Source=";
strConn += "PFS1.0.mdb;";
strConn += "Jet OLEDB:Database Locking Mode=1";

[canxing2004]

谢谢大家的帮助。。。再试试
要是通过了马上给分

[蒋晟]

估计是连错数据库了

[canxing2004]

哈哈，问题已经解决，主要是运行.net2005时候会将数据库拷贝到Debug文件夹下，覆盖下面的数据库文件，所以更改Debug下的文件没有用啦。。嘻嘻！谢谢各位的帮助！（众人：这么啰嗦，快点给分！。。。。）