我真是受不了了,这么简单的句子竟然出错!

[zcchm]

//Global.asa
<SCRIPT LANGUAGE="VBScript" RUNAT="Server">
Sub Application_OnStart
Application("ConnectionString")="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\BugManager\database\BugMng.mdb"
End Sub
</SCRIPT>

//my.asp
<OBJECT RUNAT=SERVER ID=cnn PROGID="ADODB.Connection"></OBJECT>
<%
cnn.Open Application("ConnectionString")
str = "insert into reguser (id, password, name, type) values ('a','b','c','d')"
cnn.Execute str
%>
数据库表没问题,可是运行时出现这种错误提示:
Microsoft JET Database Engine (0x80040E14)
哪位大侠救我?

[tomeli]

感觉是你的jet数据引擎有问题，你可以从微软的网站上下升级看看

[zcchm]

感谢saucer(思归)老兄,问题解决了.
能解释一下这种语法吗,标准sql没见过呀?

[saucer]

some column names are keywords, notably, password, sometimes a database like Access could give you troubles if you do not use []

[yooo120]

楼上的朋友说和有理，你试试看

[saucer]

try

str = "insert into reguser ([id], [password], [name], [type]) values ('a','b','c','d')"