Private Sub Command1_Click()
Dim tdExample As TableDef
Dim fldForeName As Field
Dim fldSurname As Field
Dim fldDOB As Field
Dim fldDO As Field
Dim fldFurtherDetails As Field
Dim dbDatabase As Database
Dim sNewDBPathAndName As String
sNewDBPathAndName = "c:\windows\temp\" & Text1.Text & ".mdb"
Set dbDatabase = CreateDatabase(sNewDBPathAndName, dbLangGeneral, dbEncrypt)
Set tdExample = dbDatabase.CreateTableDef(Text1.Text) Set fldForeName = tdExample.CreateField("Fore_Name", dbText, 20)
Set fldSurname = tdExample.CreateField("Surname", dbText, 20)
Set fldDOB = tdExample.CreateField("DOB", dbDate)
Set fldFurtherDetails = tdExample.CreateField("Further_Details", dbMemo)
Set fldDO = tdExample.CreateField("海哥", dbText, 20)
tdExample.Fields.Append fldForeName
tdExample.Fields.Append fldSurname
tdExample.Fields.Append fldDOB
tdExample.Fields.Append fldFurtherDetails
tdExample.Fields.Append fldDO
dbDatabase.TableDefs.Append tdExample
MsgBox "New .MDB Created - '" & sNewDBPathAndName & "'", vbInformation用以上代码可以建立一个完整的数据结构,但是我想在把以上的代码改一下,可以用程序向数据库里面添加或删除表!!谢谢各位仁兄了!
Dim tdExample As TableDef
Dim fldForeName As Field
Dim fldSurname As Field
Dim fldDOB As Field
Dim fldDO As Field
Dim fldFurtherDetails As Field
Dim dbDatabase As Database
Dim sNewDBPathAndName As String
sNewDBPathAndName = "c:\windows\temp\" & Text1.Text & ".mdb"
Set dbDatabase = CreateDatabase(sNewDBPathAndName, dbLangGeneral, dbEncrypt)
Set tdExample = dbDatabase.CreateTableDef(Text1.Text) Set fldForeName = tdExample.CreateField("Fore_Name", dbText, 20)
Set fldSurname = tdExample.CreateField("Surname", dbText, 20)
Set fldDOB = tdExample.CreateField("DOB", dbDate)
Set fldFurtherDetails = tdExample.CreateField("Further_Details", dbMemo)
Set fldDO = tdExample.CreateField("海哥", dbText, 20)
tdExample.Fields.Append fldForeName
tdExample.Fields.Append fldSurname
tdExample.Fields.Append fldDOB
tdExample.Fields.Append fldFurtherDetails
tdExample.Fields.Append fldDO
dbDatabase.TableDefs.Append tdExample
MsgBox "New .MDB Created - '" & sNewDBPathAndName & "'", vbInformation用以上代码可以建立一个完整的数据结构,但是我想在把以上的代码改一下,可以用程序向数据库里面添加或删除表!!谢谢各位仁兄了!
解决方案 »
- vb调用excel绘制折线图
- 那里有keybd_event的第一个参数bVk的参数表,如1对应什么120对应什么?
- 向各位请教下给软件加密的问题
- 如何在数据库中动态添加表?
- 怎样用mschart实现实时曲线
- ****combox控件的下拉框只有一列,我想显示多列如何解决****
- 求助!!关于VB中填表的控件
- Microsoft VBScript 编译器错误 错误 '800a0408'
- vb access 数据库编程
- win2000做网关,(两快网卡,1卡接通宽带,1卡接局欲网),但怎样限制客户机.
- VB下在编译COM程序时提示没有注册表的权限了,,,,,
- 如果选择了窗体的borderstyle为none之后,再用菜单编辑器添加一些菜单,这时窗体的borderstyle变为3呢。
建表create table
删除表drop table
具体语法就不写了
========================
CREATE TABLE TZ (
ID int IDENTITY(1,1) PRIMARY KEY,
Z_name varchar(20) NOT NULL)===========================删除表Drop Table TZ
dbDatabase.Execute ""CREATE TABLE tablename (FirstField TEXT 255, SecondField CURRENCY, ThirdField DATETIME, FourthField LONG);"删除表
dbDatabase.Execute "Drop Table tablename"