1,216
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command1_Click()
Dim TblNew As New Table
With TblNew
.Name = "家庭开支"
.Columns.Append "日期", adDate
.Columns.Append "收入或支出", adVarChar, 4
.Columns.Append "家庭成员", adVarChar, 20
.Columns.Append "费用", adSingle
.Columns.Append "备注", adChar
End With
If Creat_Mdb_Table(App.Path & "\nxx.mdb", TblNew) = False Then Msgbox "创建新表失败!"
Set TblNew = Nothing
End Sub
Private Function Creat_Mdb_Table(cMdbFile As String, tbl As Table) As Boolean
On Error GoTo NoTable
Dim MyCat As New ADOx.Catalog, pStr As String
Dim i As Long
Creat_Mdb_Table = True
pStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & cMdbFile
If FileCheck(cMdbFile) = False Then MyCat.Create pStr '创建新的数据库
MyCat.ActiveConnection = pStr
MyCat.Tables.Append tbl'建立数据表<---运行到这里出错跳转退出
Set MyCat = Nothing
Exit Function
NoTable:
Creat_Mdb_Table = False
Set MyCat = Nothing
End Function
Option Explicit
Dim db As Database
Dim strSQL As String
Dim cnnMDB As ADODB.Connection
Private Sub Form_Load()
Set db = DBEngine.Workspaces(0).CreateDatabase(App.Path & "\Event.mdb", dbLangGeneral _
& ";pwd=ksl")
Set db = Nothing
strSQL = "CREATE TABLE TB_Event" & "([FD_NO] LONG,[FD_Date] TEXT(50),[FD_UserName] TEXT(50)," _
& "[FD_EventType] TEXT(255),[FD_Type] TEXT(10))"
Set cnnMDB = New ADODB.Connection
cnnMDB.Provider = "Microsoft.Jet.OLEDB.4.0"
cnnMDB.Open "Data Source = " & App.Path & "\Event.mdb;jet oledb:database password=ksl"
cnnMDB.Execute strSQL
Set cnnMDB = Nothing
End Sub