Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / Languages / C#

Create a blank Jet database

4.67/5 (2 votes)
13 Nov 2010CPOL 9.6K  
And here is the long version, provided from Microsoft:http://support.microsoft.com/kb/317881/en-u[^]using System;using ADOX;namespace ConsoleApplication1{ class Class1 { [STAThread] static void Main(string[] args) { ...
And here is the long version, provided from Microsoft:

http://support.microsoft.com/kb/317881/en-u[^]

C#
using System;
using ADOX;
namespace ConsoleApplication1
{
    class Class1
    {
        [STAThread]
        static void Main(string[] args)
        {
            ADOX.CatalogClass cat = new ADOX.CatalogClass();
            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 = null;
        }
    }
}


But many thanks for the embedded version - the trick just works for all esoterism file formats we need in our projects.
And a special thanks :-O for the c style one line solution. That is a real 5 too.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)