#2
约定的童话2023-09-05 12:33
|
vb动态创建数据库,先在MSHFlexGrid1控件添加字段,然后将MSHFlexGrid1控件中的字段生成数据表,运行时出现 “实时错误429 ActiveX部件不能创建对象”提示。请师傅指点迷津!
生成表的代码如下:
Private Sub Command2_Click() '生成数据库表
Dim PathName As String
PathName = App.Path
If Right(PathName, 1) <> "\" Then
PathName = PathName & "\"
End If
Dim aaa As Variant
Dim i As Integer
Dim MyTable As TableDef, MyField As Field
Dim MyDatabase As Database
Set MyDatabase = CreateDatabase(PathName & Text4.Text, dbLangGeneral)
Set MyTable = MyDatabase.CreateTableDef(Text2.Text)
For i = 1 To 12
If MSHFlexGrid1.TextMatrix(i, 1) <> "" Then
aaa = MSHFlexGrid1.TextMatrix(i, 2)
Set MyField = MyTable.CreateField(MSHFlexGrid1.TextMatrix(i, 1), aaa, 50)
MyTable.Fields.Append MyField
End If
Next i
MyDatabase.TableDefs.Append MyTable
End Sub