Create Database

[WoodyRoundUp]

Hi there.
May I know how can I create a Database with coding?
Please guide me through.
Coz I am new in programming.
Thanks.

Budi

 

[Foada]

What kind of database? Can you give any more details? If you choose to battle wits with the witless be prepared to lose.

 

[WoodyRoundUp]

hi there.
what i want to create is a simple database with one table.
the creation of the table is not a problem. i can deal with that. i just dunno how to create a mdb file (which does not exist before), by using coding.
i really need help on this.
thanks for your help.

budi

 

[WoodyRoundUp]

what i mean is the Access database.
sorry.

budi

 

[Foada]

Here is some code to get you started

'Add a reference to ADO Ext 2.xx for DLL and Security
Private Sub cmdCreateDB_Click()
Dim cat As New ADOX.Catalog
Dim tbl As New Table
Dim sConnection As String

sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\newDBName.mdb"
cat.Create sConnection
cat.ActiveConnection = sConnection
tbl.Name = "newTableName"
tbl.Columns.Append "newColumn1Name", adInteger
tbl.Columns.Append "newColumn2Name", adVarWChar, 25
cat.Tables.Append tbl

Set tbl = Nothing
Set cat = Nothing
End Sub

Let me know if it helps. If you choose to battle wits with the witless be prepared to lose.

 

[WoodyRoundUp]

yup.
thanks for your help.
it works.

thanks again.

budi