高手救命,在线等!!!

1   
2StrSQL="DBQ="+server.mappath("mydatabase.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"   
3set conn=server.createobject("ADODB.CONNECTION")   
4conn.open StrSQL   
5sql="CREATE TABLE mytable (prodid INT(16))"   
6conn.Execute sql   

运行后系统提示:
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] CREATE TABLE 语句中的语法错误。
不解,请高手帮忙,非常感谢!!!
---------------------------------------------------------------

CREATE TABLE mytable1 (prodid int)

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

CREATE TABLE mytable (prodid int)

INT不能指定长度
ACCESS的SQL不是很标准

Published At
Categories with Web编程
Tagged with
comments powered by Disqus