Imports Adox
Module Module1
Public Function CreateAccessDB (ByVal NewDBPathName As String) As Integer Dim i As Integer = 1 Dim cat As Catalog = New Catalog () Try cat.Create ( "Provider = Microsoft.Jet.OLEDB.4.0;" & _ "Data Source =" & NewDbpathname & _ "Jet OLEDB: Engine Type = 5")
'Console.Writeline ("Database Created SuccessFully) Catch i = 0 msgbox (" Error Number: "& Err.Number.toToString &" Error Description: "& Err.Description.toString)
END TRY
Cat = Nothing returni end function
End module
Imports System.IoImports Adox
Public class form1 inherits system.windows.Forms.form Dim filename as string = ""
#Region "Windows Form Designer Generated Code"
Public Sub new () mybase.new ()
'This call is required for the Windows Form Designer. InitializeComponent ()
'Add any initialization after INITIALIZECOMPONENT ()
End Sub
'Form rewriting disposal to clean the component list. Protected overloads overrides sub dispose (byval disposing as boolean) ing disponation kiln (Components Is Nothing) Then components.dispose () end if endiffs) End sub
'Windows Form Designer Supply Private Components as System.comPonentModel.icontainer
'Note: The following procedure is necessary to use the Windows Form Designer to modify this process using the Windows Form Designer. 'Don't modify it using the code editor.
Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents SaveFileDialog1 As System.Windows.Forms.SaveFileDialog Friend WithEvents SaveFileDialog2 As System.Windows.Forms.SaveFileDialog Friend WithEvents Button2 As System.Windows.Forms.Button
New system.drawing.size (592, 286) me.controls.addrange (new system.windows.Forms.control () {me.button2, me.button1}) me.name = "Form1" me.text = "Form1 "Me.ResumeLayout (false) End Sub
#End region
PRIVATE SUB button1_click (Byval E AS System.EventArgs) Handles Button1.Click Dim Str1 As String = "D: / MRFU / NewAccess" DIM STR2 AS STRING = "NewAccess"
IF file.exists ("D: /MRFU/newmdb.mdb") THEN MSGBOX ("The File Have EXISTS!") EXIT SUB
END IF CREATEACCESSDB (STR1) THEN MSGBOX ("Sucess!") Else Msgbox ("failed!")
End if 'me.savefiledialog1
End Sub
Private sub Button2_click (byvalgend, byval e as system.eventargs) Handles Button2.click
With me.savefiledialog1 .addextension = True
.Defaultext = "MDB" .checkpathexists = true .filter = "(access database) *. MDB | * .mdb" .overwriteprompt = true
.Filterindex = 1 End with
If me.savefiledialog1.showdialog () = DialogResult.ok then
Filename = me.savefiledialog1.filename if filename <> "" THEN MSGBOX (filename) Else Exit Sub
END if endiff
If File.exists (FileName) THEN MSGBOX ("The File Have EXISTS!") File.Delete (FileName) Msgbox ("Had Delete!")
END IF
Filename = filename & ";" msgbox (filename)
If CreateAccessDB (FileName) THEN MSGBOX ("Sucess!") Else Msgbox ("failed!")
End if End Subend Class
