VB中代碼創建數據庫

´先引用Mcrsoft DAO 3.6(或2.5或3.51) Object Library和Mcrsoft Aclearcase/" target="_blank" >ccess 9.0 Object Library，在Form上加個Command1,粘貼以下代碼：

Private Sub Command1_Click()
   Dim wrkDefault As Workspace
   Dim dbsNew As Database
   Dim tdfNew As TableDef
   Dim NewDB As Database

   If Dir("D:\NewDB.mdb") <> "" Then Kill "D:\NewDB.mdb"
      ´{取當前目錄的話去掉路徑： If Dir("NewDB.mdb") <> "" Then Kill "NewDB.mdb")}
   Set wrkDefault = DBEngine.Workspaces(0)
   Set dbsNew = wrkDefault.CreateDatabase("d:\NewDB.mdb", dbLangGeneral, dbEncrypt)
      ´{取當前目錄的話去掉路徑： Set dbsNew = wrkDefault.CreateDatabase("NewDB.mdb", dbLangGeneral, dbEncrypt)}
      
   dbsNew.NewPassword "", "123" ´設置數據庫密碼為123
  
  
   Set wrkDefault = Nothing
   Set dbsNew = Nothing

End Sub

原文轉自：http://www.anti-gravitydesign.com