请问在VB中能否用语句实现创建一个ACCESS试图?如何实现?有例子将不胜感激
解决方案 »
- 使用c dll裡function pointer的問題
- vb.net2005 操控 project2007 类的申请问题
- 数组小问题
- 用vb如何锁定键盘?
- 用wininet实现ftp客户端功能?怎么实现啊,大侠救命!
- evb是什么?以前没听到过,请告知,谢
- 如何不使用WinSock控件,而用API来定义一个WinSock对象?
- ABAP培训是否值得,ABAP就业前景
- VB关键字
- 如何侦错? ---- 实时错误 '-2147217887(80040e21)多步OLE DB操作产生错误。请检查每个OLE DB状态值,没有工作被完成。
- 高手请进,如何使用LoadString函数?为何我的做法不对???分不够可以再加!!!
- 各位大哥,小弟有一问题急需解决。
用
Create View 视图名
as
sql语句
Dim DB As Database
Dim TD As TableDef
Dim FLD As Field
Dim IDX As Index
Dim rd As Recordset
Set WS = DBEngine.Workspaces(0)
Set DB = WS.CreateDatabase("copyright.mdb", dbLangGeneral)
DB.Connect = ";pwd=andy"
Set TD = DB.CreateTableDef("Authorize_Date")
TD.Attributes = 0
TD.Connect = ""
TD.SourceTableName = ""
TD.ValidationRule = ""
TD.ValidationText = ""
'Field First_Time
Set FLD = TD.CreateField("First_Time", 8, 8)
FLD.Attributes = 1
FLD.DefaultValue = ""
FLD.OrdinalPosition = 0
FLD.Required = False
FLD.ValidationRule = ""
FLD.ValidationText = ""
TD.Fields.Append FLD
'Field Last_Time
Set FLD = TD.CreateField("Last_Time", 8, 8)
FLD.Attributes = 1
FLD.DefaultValue = ""
FLD.OrdinalPosition = 1
FLD.Required = False
FLD.ValidationRule = ""
FLD.ValidationText = ""
TD.Fields.Append FLD
'Field Times
Set FLD = TD.CreateField("Times", 3, 2)
FLD.Attributes = 1
FLD.DefaultValue = ""
FLD.OrdinalPosition = 2
FLD.Required = False
FLD.ValidationRule = ""
FLD.ValidationText = ""
TD.Fields.Append FLD
Set FLD = TD.CreateField("Authorize", 10, 17)
FLD.Attributes = 1
FLD.DefaultValue = ""
FLD.OrdinalPosition = 3
FLD.Required = False
FLD.ValidationRule = ""
FLD.ValidationText = ""
TD.Fields.Append FLD
DB.TableDefs.Append TD
DB.Close