ASP.NET 中使用OleDbCommand对access数据库更新，提示错误 急！

[ghzboy]

语句如下
Dim conn As New OleDbConnection
Dim command As New OleDbCommand
Dim Commandsql As String
Dim selNum As New Integer
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|db\register.mdb"
conn.Open()
Commandsql = "insert into 变更临时表 (企业名称,变更项目,bgid,经营范围,user,lrdate) values ('" & qymc_text.Text & "','" & bgxmRecord & "','" & bgidRecord & "','" & jyfw_text.Text & "','" & Session("userid").ToString & "','" & Now.ToShortDateString & "')"

command.CommandText = Commandsql
command.Connection = conn
command.ExecuteNonQuery()
conn.Close()
该插入语句
"insert into 变更临时表 (企业名称,变更项目,bgid,经营范围,user,lrdate) values ('ddddddddd','名称|地址','1|2','aaaaaaa','1','2009-03-01')"
在Access中单独运行没有问题

但是在运行时提示如下错误，请高手帮忙
用户代码未处理 System.Data.OleDb.OleDbException
ErrorCode=-2147217900
Message="INSERT INTO 语句的语法错误。"
Source="Microsoft JET Database Engine"
StackTrace:
在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
在 System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
在 bg.display_button_Click(Object sender, EventArgs e) 位置 H:\WebSite\WebSite1\register\bg.aspx.vb:行号 217
在 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
在 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
在 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
在 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
在 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[smartxue1987]

改为 string ACsql = "insert into 变更临时表 (企业名称,变更项目,bgid,经营范围,user,lrdate)values(\"" + qymc_text.Text + "\",\"" + bgxmRecord + "\",\"" + jyfw_text.Text + "\",\"" + Session("userid").ToString + "\",\"" + Now.ToShortDateString + "\",)";

试试看

[vbman2003]

试试SQL语句中，将字段user加上[]号：
"insert into 变更临时表 (企业名称,变更项目,bgid,经营范围,[user],lrdate) values..."

[ghzboy]

多谢 vbman2003， 问题解决，结贴