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]]

"gaffar" <sa********@yah oo.co.in> schrieb:

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.microso ft.com/?scid=kb;EN-US;317867>

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

+

<URL:http://search.microsof t.com/search/results.aspx?&V iew=en-us&qu=ADOX>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Dennis]

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("Pro vider=Microsoft .Jet.OLEDB.4.0; " & _
"Data Source=D:\Acces sDB\NewMDB.mdb; " & _
"Jet OLEDB:Engine Type=5")
Console.WriteLi ne("Database Created Successfully")
cat = Nothing
End Sub

"gaffar" wrote:

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.