How to Create ACCESS Database from VB code.

[alexk]

How can I create ACCESS Database using VB.NET code???
In old version I was use code:
DAODBEngine.Workspaces(0).CreateDatabase(DBName, ..., ...)
But how do it in VB.NET?

 

[rmatthew]

Finally a question I can answer!!!!!

This is my first time trying to answer a question so I hop I get this right (use at your own risk.) - BUT works for me in my app.

catalog = CreateObject("ADOX.Catalog")
catalog.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path)


Hope that helps

 

[Robby]

rmatthew, that is not a .NET method, it still uses COM.

I guess since Im not able to provide a solution using .NET, Ill go away now.

 

[Robby]

In case you want to use ADOX , heres a sample from our own Thinker. www.visualbasicforum.com/showthread.php?s=&threadid=20002

 

[rmatthew]

You are right - uses COM

Only way I am aware of - sorry