Example code to create an MS Access db locally using VB.Net 2003

[John]

Hi,

I am a beginner looking for example code on how to create an access
database for a local application. I need to create the database when
the app is first installed. I can do it with SQL 2000 but I am not
sure how to do create a db, tables and fields as a local mdb. Any help
or pointers to where I can find example code on this much appreciated.

Thanks
John

[Miha Markic]

Hi John,

See
ACC: Create and Drop Tables and Relationships Using SQL DDL
http://support.microsoft.com/default...45&Product=acc
and
HOWTO: Common DDL SQL for the Microsoft Access Database Engine
http://support.microsoft.com/default...41&Product=acc

It is not directly related to ado.net.
You will have to execute those ddl commands via
OleDbCommand.ExecuteNonQuery() method.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"John" <jo**@hokykoky.com> wrote in message
news:5a**************************@posting.google.c om...

Hi,

I am a beginner looking for example code on how to create an access
database for a local application. I need to create the database when
the app is first installed. I can do it with SQL 2000 but I am not
sure how to do create a db, tables and fields as a local mdb. Any help
or pointers to where I can find example code on this much appreciated.

Thanks
John

[Cor]

Hi John,

set a reference to COM adox ext 2.x for dll and security
\\\
Dim catNewDB As New ADOX.Catalog
catNewDB.Create("Provider=Microsoft.Jet.OLEDB.4.0; " & "Data
Source=C:\db1.mdb")
///
I hope this helps a little bit?

Cor

I am a beginner looking for example code on how to create an access
database for a local application. I need to create the database when
the app is first installed. I can do it with SQL 2000 but I am not
sure how to do create a db, tables and fields as a local mdb. Any help
or pointers to where I can find example code on this much appreciated.

[John]

Thanks for this guys, I will give it a try and see what happens.
Regards
John
"Cor" <no*@non.com> wrote in message news:<#R**************@TK2MSFTNGP10.phx.gbl>...

Hi John,

set a reference to COM adox ext 2.x for dll and security
\\\
Dim catNewDB As New ADOX.Catalog
catNewDB.Create("Provider=Microsoft.Jet.OLEDB.4.0; " & "Data
Source=C:\db1.mdb")
///
I hope this helps a little bit?

Cor

I am a beginner looking for example code on how to create an access
database for a local application. I need to create the database when
the app is first installed. I can do it with SQL 2000 but I am not
sure how to do create a db, tables and fields as a local mdb. Any help
or pointers to where I can find example code on this much appreciated.