这是怎么回事？?????????????

[plblackeagle]

我执行下列代码老是错误：

private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click


Dim DBComm As OleDbCommand : Dim Conn As OleDbConnection
Dim ConnStr As String : Dim DBStr As String
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Main.mdb")
DBStr = "insert into GroupName Values('" & TextBox1.Text & "')"

CreateMyOleDbCommand(DBStr, ConnStr)
End Sub


Public Sub CreateMyOleDbCommand(ByVal myExecuteQuery As String, _
ByVal myConnectionString As String)
Dim myConnection As New OleDbConnection(myConnectionString)
Dim myCommand As New OleDbCommand(myExecuteQuery, myConnection)
myCommand.Connection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()

End Sub


操作必须使用一个可更新的查询。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.OleDb.OleDbException: 操作必须使用一个可更新的查询。

[blp]

你跟踪一下，把dbstr的sql语句拿到access的查询器中去运行一下。再检查一下约束。
insert SQL用法
insert into tableName (fieldName1,fieldname2,...) values (fieldValue1,fieldValue2,...)

[lijiajia]

注意你要操作的权限。