有关用SQL命令插入数据

Dim objComm

Set objComm = Server.CreateObject("ADODB.Command")

objComm.ActiveConnection=strConnect

objComm.CommandText="INSERT INTO Users (ID, User, Password) VALUES (" & intNewNumber & ",'" & strName & "', " & "'" & strPassword & "')"

objComm.CommandType=adCmdText

objComm.Execute

为什么总说INSERT INTO语句语法错误？

---------------------------------------------------------------

INSERT INTO [Users] (ID, [User], Password) VALUES (" & intNewNumber & ",'" & strName & "', " & "'" & strPassword & "')"
Users和User均是SQL SERVER保留关键字
---------------------------------------------------------------

INSERT INTO Users (ID, [User], Password) VALUES (" & intNewNumber & ",'" & strName & "', " & "'" & strPassword & "')"
还要看id 是不是自动编号 是的话不能插入！

---------------------------------------------------------------

同意tripofdream的做法。
这一句改为
objComm.CommandText="INSERT INTO Users (ID, User, Password) VALUES (" & intNewNumber & ",'" & strName & "', " & "'" & strPassword & "')"

objComm.CommandText="INSERT INTO [Users] (ID, [User], Password) VALUES (" & intNewNumber & ",'" & strName & "', " & "'" & strPassword & "')"