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不是很标准