请教access建表语句问题

[methebestlj]

string Sql = "CREATE TABLE [" + DataTable + "](" +
"[Id] [autonumber]," +
"[ChID] [long] NOT NULL ," +//信息ＩＤ
"[title] [varchar](100) NOT NULL ," +//标题
"[ClassID] [long] NOT NULL ," +//栏目
"[SpecialID] [text] (200) NULL ," +//专题
"[TitleColor] [text] (10) NULL ," +//标题颜色
"[TitleITF] [byte] NULL ," +//标题是否为斜体
"[TitleBTF] [byte] NULL ," +//标题是否为粗体
"[PicURL] [text] (200) NULL ," +//图片地址
"[Content] [memo] NULL ," +//内容描述
"[NaviContent] [text] (200) NULL ," +//内容导读
"[ContentProperty] [text] (9) NULL ," +//属性,推荐|热点|幻灯|滚动|头条
"[Author] [text] (100) NULL ," +//作者
"[Editor] [text] (50) NULL ," +//编辑
"[Souce] [text] (100) NULL ," +//来源
"[OrderID] [byte] NOT NULL ," +//权重
"[Tags] [text] (100) NULL ," +//关键字
"[Templet] [text] (200) NULL ," +//模板
"[SavePath] [text] (200) NULL ," +
"[FileName] [text] (100) NULL ," +//包含扩展名
"[isDelPoint] [byte] NOT NULL ," +//是否具有浏览权限
"[Gpoint] [long] NULL ," +//G币
"[iPoint] [long] NULL ," +//积分
"[GroupNumber] [memo] NULL ," +//会员组
"[Metakeywords] [text] (200) NULL ," +//meta关键字
"[Metadesc] [text] (200) NULL ," +//meta描述
"[Click] [long] NULL ," +//点击
"[CreatTime] [datetime] NULL ," +//创建日期
"[isHTML] [byte] NOT NULL ," +//是否生成了静态
"[isConstr] [byte] NOT NULL ," + //专区
"[ConstrTF] [byte] NOT NULL ,"; //投稿审核
Sql += "[islock] [byte] NULL )";

请问这个access建表语句有什么问题？

[zhulong1111]

up

[methebestlj]

?

[glboy12]

没看出来..

[xiaojing7]

没什么问题吧，你在什么地方运行，直接在程序中？

[methebestlj]

在.net里面 提示System.Data.OleDb.OleDbException: 字段定义语法错误

[yeinuse]

"[title] [varchar](100) NOT NULL ," ///第四行错误，varchar是SQL SERVER中的类型。
放在access中吗？？应该换成？："[title] [text](100) NOT NULL ,"

[银狐被占用]

好像不应该有VARCHAR。

[rqx110]

好多问题～～～～

[methebestlj]

[Quote=引用 6 楼 yeinuse 的回复:]
"[title] [varchar](100) NOT NULL ," ///第四行错误，varchar是SQL SERVER中的类型。
放在access中吗？？应该换成？："[title] [text](100) NOT NULL ,"
[/Quote]

改过了，还是不行，autonumber这个类型有问题么？

[ralpha08]

http://access911.net/fixhtm/74FAB01E15DC.htm?tt=

Access数据库动态建表只能用ADODB.CONNECTION.EXECUTE 或者 ADOX来完成，用OLEDBConnection会报错
建议还是在access中预先建好你需要的表

[methebestlj]

CREATE TABLE [NT_channel_product3]([Id] counter CONSTRAINT id PRIMARY KEY,[ChID] long NOT NULL ,title text(100) NOT NULL ,[ClassID] long NOT NULL ,[SpecialID] text (200) NULL ,[TitleColor] text (10) NULL ,[TitleITF] byte NULL ,[TitleBTF] byte NULL ,[PicURL] text (200) NULL ,[Content] memo NULL ,[NaviContent] text (200) NULL ,[ContentProperty] text (9) NULL ,[Author] text (100) NULL ,[Editor] text (50) NULL ,[Souce] text (100) NULL ,[OrderID] byte NOT NULL ,[Tags] text (100) NULL ,[Templet] text (200) NULL ,[SavePath] text (200) NULL ,[FileName] text (100) NULL ,[isDelPoint] byte NOT NULL ,[Gpoint] long NULL ,[iPoint] long NULL ,[GroupNumber] memo NULL ,[Metakeywords] text (200) NULL ,[Metadesc] text (200) NULL ,[Click] long NULL ,[CreatTime] datetime NULL ,[isHTML] byte NOT NULL ,[isConstr] byte NOT NULL ,[ConstrTF] byte NOT NULL)

谢谢各位，找到原因了,autonumber改成 counter CONSTRAINT id PRIMARY KEY,类型不能用[] 比如[text]