insert inot 语句语法错误

[tobyFrank]

Dim dbconn As OleDbConnection
dbconn = New OleDbConnection(ConfigurationSettings.AppSettings"connectionstring"))
dbconn.Open()
Dim dbcommand As OleDbCommand

Dim rolename, description, oskey, sqlstring As String
rolename = "tobyhh"
description = "123456"
oskey = "system"

sqlstring = "insert into test(name,password,oskey) " _
& "values('" + rolename + "','" + description + "','" + oskey + "')"
dbcommand = New OleDbCommand(sqlstring, dbconn)
dbcommand.ExecuteNonQuery()
注:使用access数据库中的表.字段全为文本字段,老是提示insert inot 语句语法错误

[skyboy0720]

Response.Write sqlstring

[netexe]

insert into test([name],password,oskey)

[menrock]

VB.NET是用&号的吧

[lonkil]

你把ACCESS修复一下，再试试

[danis_cn]

Response.Write sqlstring看看

然后把这条语句在access中运行看看什么提示

[Macon8800]

name 是关键字用[]括起来看看

[杨米格]

用了字段名用了SQL里的关键字了,查一查,改个名就没有问题了

[tobyFrank]

输出sqlstring 为insert into test(name,password,oskey) values('tobyhh','123456','system')

[tobyFrank]

谢谢各位,就是关键字的问题.