form1.frm

vb数据库编程资料

VERSION 5.00
Begin VB.Form Form1 
   Caption         =   "Form1"
   ClientHeight    =   1500
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   4665
   LinkTopic       =   "Form1"
   ScaleHeight     =   1500
   ScaleWidth      =   4665
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "列出所有DBEngine的工作区对象和属性名"
      Height          =   495
      Left            =   0
      TabIndex        =   0
      Top             =   480
      Width           =   4455
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
 Call DBEngineX
End Sub
Sub DBEngineX()
DBEngine.Workspaces(0).CreateDatabase
   Dim wrkLoop As Workspace
   Dim prpLoop As Property
   With DBEngine
      Debug.Print "DBEngine Properties"
      ' Enumerate Properties collection of DBEngine,
      ' trapping for properties whose values are
      ' invalid in this context.
      For Each prpLoop In .Properties
         On Error Resume Next
         Debug.Print "  " & prpLoop.Name & " = " _
            & prpLoop
         On Error GoTo 0
      Next prpLoop
      Debug.Print "Workspaces collection of DBEngine"
      ' Enumerate Workspaces collection of DBEngine.
      For Each wrkLoop In .Workspaces
         Debug.Print "  " & wrkLoop.Name
         ' Enumerate Properties collection of each
         ' Workspace object, trapping for properties
         ' whose values are invalid in this context.
      Next wrkLoop
   End With
End Sub