.net操作Access数据库时出错
Dim objCommand As OleDb.OleDbCommand
Dim objConnect As OleDb.OleDbConnection
Dim m_strAccessConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "F:\mdb\MyAccess.mdb"
objConnect = New OleDb.OleDbConnection(m_strAccessConnection )
objConnect .Open()
objCommand = New OleDb.OleDbCommand(strSql, objConnect)
objCommand .CommandTimeout = 60
objCommand .ExecuteNonQuery()
~~~~~~~~~~~~~~~~报错,插入不成功,但单独运行SQL是好使的。
用的是XPPro的Access,请高手指教。