creating accdb file from C#

Question

I want to create Ms access2007 file programatically from c# using Microsoft.ACE.OLEDB.12.0

It's nice to know what you want to do. A proper question would explain what it is you actually need help with, including what you've already tried that doesn't work, etc. — David-W-Fenton
– David-W-Fenton, Commented Jan 13, 2011 at 2:33

apros · Accepted Answer · 2011-01-13 12:30:23Z

4

Here is some example:

    using System;
    using ADOX;

    namespace ConsoleApplication1
    {
        class Class1
        {
            [STAThread]
            static void Main(string[] args)
            {
                ADOX.Catalog cat = new ADOX.Catalog();

                cat.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;");

                Console.WriteLine("Database Created Successfully");

                cat = null;

            }
        }
    }

edited Jan 13, 2011 at 12:30

answered Jan 12, 2011 at 15:06

apros

2,8783 gold badges27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Wisam Over a year ago

Thanks for the answer Build I have already try it and i got the message: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." My code : ADOX.CatalogClass cat = new ADOX.CatalogClass(); cat.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Tmp.accdb;Persist Security Info=False;");

Wisam Over a year ago

Oh yahhh I Resolve it cat.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;;Jet OLEDB:Engine Type=5;"); Thanks any way

apros Over a year ago

Sorry for inconvinience, I also have made some changes to my code, so that it is work properly.

ToyAuthor X Over a year ago

<Microsoft ADO Ext. 6.0 for DDL and Security> for ADOX

Collectives™ on Stack Overflow

creating accdb file from C#

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related