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.aspx?scid=kb;en-us;116145&Product=acc
and
HOWTO: Common DDL SQL for the Microsoft Access Database Engine
http://support.microsoft.com/default.aspx?scid=kb;en-us;180841&Product=acc

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

 

[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

 

[John]

Thanks for this guys, I will give it a try and see what happens.
Regards
John