我的测试代码应该没有错啊,可就是插入不了数据string strConn = @" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = d:\db2.mdb " ;
//string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=andy;Data Source=D:\db1.mdb;Mode=Share Deny None";
OleDbConnection myConn = new OleDbConnection ( strConn ) ;
try
{
myConn.Open();
string strInsert = "insert into noterecord([record],[createdate]) values('111','1980-12-3')";
OleDbCommand inst = new OleDbCommand ( strInsert , myConn ) ;
inst.ExecuteNonQuery ( ) ;
}
catch(Exception ex)
{
Label1.Text=ex.ToString();
}
finally
{
myConn.Close ( ) ;
}
//string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=andy;Data Source=D:\db1.mdb;Mode=Share Deny None";
OleDbConnection myConn = new OleDbConnection ( strConn ) ;
try
{
myConn.Open();
string strInsert = "insert into noterecord([record],[createdate]) values('111','1980-12-3')";
OleDbCommand inst = new OleDbCommand ( strInsert , myConn ) ;
inst.ExecuteNonQuery ( ) ;
}
catch(Exception ex)
{
Label1.Text=ex.ToString();
}
finally
{
myConn.Close ( ) ;
}
string strInsert = "insert into noterecord(record,createdate) values('111','1980-12-3')";
string strInsert = "insert into noterecord([record],[createdate]) values('111',#1980-12-3#)";
你可以设置该文件夹的ACL,使之对Everyone组有写入权限就行了.