.net - How to create Microsoft Access database in C# programmatically?

Question

How do you create a Microsoft Access database file in C# if it does not exist yet?

Answer 1

The simplest answer is to embed an empty .mdb / .accdb file in your program and write it out to disk.

The correct answer is to use COM Interop with the ADOX library:

var cat = new ADOX.Catalog()
cat.Create(connectionString);

Remember to generate your connection strings using OleDbConnectionStringBuilder.