111,125
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
copico 2006-05-23
- 打赏
- 举报
哦,我弄的SQL的
chequan 2006-05-22
- 打赏
- 举报
Access似乎不支持CREATE DATABASE
chequan 2006-05-22
- 打赏
- 举报
copico(一路向北)，不行的，你的那个SQL语句在Access是通不过的哟！
copico 2006-05-22
- 打赏
- 举报
strSQL = "CREATE DATABASE " & databasename
chequan 2006-05-22
- 打赏
- 举报
建库呢，可否用Create database？谢谢！
copico 2006-05-22
- 打赏
- 举报
strSQL = "CREATE TABLE FileCaption(" & _
"id int not null IDENTITY PRIMARY KEY ," & _
"FileName varchar(512) not null," & _
"FileAssoc varchar(255) ," & _
"FileTitle varchar(255) ," & _
"Folder varchar(50) ," & _
"lsOpen bit ," & _
"TreeNode varchar(50) ," & _
"FileDeny int ," & _
"StartTime datetime ," & _
"FilePath varchar(260) ," & _
"lsRefresh bit ," & _
"fileld int )"
"id int not null IDENTITY PRIMARY KEY ," & _
"FileName varchar(512) not null," & _
"FileAssoc varchar(255) ," & _
"FileTitle varchar(255) ," & _
"Folder varchar(50) ," & _
"lsOpen bit ," & _
"TreeNode varchar(50) ," & _
"FileDeny int ," & _
"StartTime datetime ," & _
"FilePath varchar(260) ," & _
"lsRefresh bit ," & _
"fileld int )"
