Using ADOX to create a JET Database

[gaffar]

Hello Sir,
i need the funtionality of Using ADOX to create a JET Database and tables in
it and one to many relationship between the tables.

Thanks for your help
Gaffar.

 

[Herfried K. Wagner [MVP]]

i need the funtionality of Using ADOX to create a JET Database and tables
in
it and one to many relationship between the tables.

HOW TO: Create a Microsoft Access Database Using ADOX and Visual Basic .NET
<http://support.microsoft.com/?scid=kb;EN-US;317867>

HOW TO: Create an Access Database Using ADOX and Visual C# .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;317881>

+

<URL:http://search.microsoft.com/search/results.aspx?&View=en-us&qu=ADOX>

 

[Guest]

In Solution Explorer, right-click the References node, and then click Add
Reference.
In the Add Reference dialog box, click the COM tab, click Microsoft ADO Ext.
2.7 for DDL and Security, click Select to add it to the Selected Components
section, and then click OK.
Imports ADOX
Module Module1
Sub Main()
Dim cat As Catalog = New Catalog()
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\AccessDB\NewMDB.mdb;" & _
"Jet OLEDB:Engine Type=5")
Console.WriteLine("Database Created Successfully")
cat = Nothing
End Sub