creating an access table in a db
hi,
I just want to create a table in an existing access db in vb.
Someone could help me ? I just can't figure out how.
here's some code
Code:
Private Sub cmdSaveBD_Click()
Dim accessApp As Object
dlg.Filter = "Microsoft Access database (*.mdb)|*.mdb"
dlg.Flags = cdlOFNOverwritePrompt
dlg.CancelError = True
dlg.ShowSave
If Err.Number = cdlCancel Then
'User selected cancel
Exit Sub
End If
bdPath = dlg.FileName
Set accessApp = CreateObject("Access.Application")
accessApp.NewCurrentDatabase bdPath
'Here I want to create my table
'....
accessApp.Quit acQuitSaveAll
End Sub