locked
How to create a .mdb file with tables in it? RRS feed

  • Question

  • Hey guys!

    I want my C#-program to create automatically a .mdb file with tables in it.

    How can I do that?

    Please answer.

    Wednesday, January 23, 2013 6:01 PM

Answers

  • This web page will tell you how to use interop to ADOX to create an Access database.

    http://support.microsoft.com/kb/317881

    After that you can use ExecuteNonQuery after getting a connection to the new database to create tables using normal CREATE TABLE statements.

    • Proposed as answer by RohitArora Thursday, January 24, 2013 4:03 AM
    • Marked as answer by Mike Feng Monday, February 4, 2013 5:15 AM
    Thursday, January 24, 2013 12:22 AM