这个是我的一段代码:
Private Sub Form_Load()
'创建对象
Dim mydatabase As Database'创建数据库
Set mydatabase = Workspaces(0).CreateDatabase("c:\mydata1.mdb", dbLangGeneral, dbversion70)'创建表
Dim mytabledef As TableDef
Set mytabledef = mydatabase.CreateTableDef("mytable1")'创建字段
Dim myfield As Field
Set myfield = mytabledef.CreateField("序列号", dbText, 20)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("产品型号", dbText, 30)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("生产日期", dbDate)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("客户名称", dbText, 40)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("注释", dbText, 200)
mytabledef.Fields.Append myfieldDim myindex As Index
Set myindex = mytabledef.CreateIndex("序列号索引")
myindex.Primary = True
Set myfield = myindex.CreateField("序列号")
myindex.Fields.Append myfield
mytabledef.Indexes.Append myindexEnd Sub这样可以在程序开始建立数据库,但如果已经存在数据库,就会提示错误.我想让它在不存在的时候建立,如果存在就针对已经存在的数据库进行操作,应该怎么修改呢?还有,如果我想让这个数据库建立到程序当前目录下,应该怎么写呢?
Private Sub Form_Load()
'创建对象
Dim mydatabase As Database'创建数据库
Set mydatabase = Workspaces(0).CreateDatabase("c:\mydata1.mdb", dbLangGeneral, dbversion70)'创建表
Dim mytabledef As TableDef
Set mytabledef = mydatabase.CreateTableDef("mytable1")'创建字段
Dim myfield As Field
Set myfield = mytabledef.CreateField("序列号", dbText, 20)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("产品型号", dbText, 30)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("生产日期", dbDate)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("客户名称", dbText, 40)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("注释", dbText, 200)
mytabledef.Fields.Append myfieldDim myindex As Index
Set myindex = mytabledef.CreateIndex("序列号索引")
myindex.Primary = True
Set myfield = myindex.CreateField("序列号")
myindex.Fields.Append myfield
mytabledef.Indexes.Append myindexEnd Sub这样可以在程序开始建立数据库,但如果已经存在数据库,就会提示错误.我想让它在不存在的时候建立,如果存在就针对已经存在的数据库进行操作,应该怎么修改呢?还有,如果我想让这个数据库建立到程序当前目录下,应该怎么写呢?
解决方案 »
- 谁有VB选择性拔号的源程序?
- 请问在vb中如何调用autocad自动绘制图
- 关于文本框的按回程 发送TAB的问题!~
- 再问关于SQL语句问题[Access 2000 数据库]
- 在WindowsXP中用打印机为什么没有自定纸张,怎么样才有?急!
- 串口控制协议怎样才能让MSComm控件的Sttings:1200,n,8,1来关联在下拉菜单中选择波特率数据?
- DeleteDC DeleteObject 出错为什么?VB,API高手请进
- 求 模拟刷卡器 的代码
- 请问高手学习VB的方向以及经典的参考书有哪些?
- VB6.0 调用dll 如何声明如下两个函数
- 想转Delphi的朋友关注:李维经典书籍1元起拍卖!!!
- 如何在SQL语句中含有“'”字符串进行查询
Dim mydatabase As DatabaseOn Error GoTo creatdatabase
Set mydatabase = OpenDatabase(App.Path & "\mydata1.mdb")
Exit Subcreatdatabase:
'创建对象
''创建数据库
Set mydatabase = Workspaces(0).CreateDatabase(App.Path & "\mydata1.mdb", dbLangGeneral, dbversion70)'创建表
Dim mytabledef As TableDef
Set mytabledef = mydatabase.CreateTableDef("mytable1")'创建字段
Dim myfield As Field
Set myfield = mytabledef.CreateField("序列号", dbText, 20)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("产品型号", dbText, 30)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("生产日期", dbDate)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("客户名称", dbText, 40)
mytabledef.Fields.Append myfieldSet myfield = mytabledef.CreateField("注释", dbText, 200)
mytabledef.Fields.Append myfieldDim myindex As Index
Set myindex = mytabledef.CreateIndex("序列号索引")
myindex.Primary = True
Set myfield = myindex.CreateField("序列号")
myindex.Fields.Append myfield
mytabledef.Indexes.Append myindexResumeEnd Sub