Create a Access Database in C#

2004-05-11T11:22:00.000-07:00

Here is a little function that can be inserted into any C# project for a quick creation of an MSAccess Database

using ADOX;

private void CreateDB()
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";
string strFileName = null;

using (SaveFileDialog dlgOpen = new SaveFileDialog())
{
dlgOpen.Title = "New Database Name";
dlgOpen.Filter = "Microsoft Access Files (*.mdb) | *.mdb";
DialogResult dlgResult = dlgOpen.ShowDialog();
if (dlgResult == DialogResult.OK)
strFileName = dlgOpenFileName.ToString();
}
if (strFileName != null)
{
strConn += strFileName;
ADOX.CataLogClass cat = new ADOX.CatalogClass();
cat.create(strConn + "; Jet OLEDB:Engine Type = 5");
cat=null;
}
}

Fhaze Out

Create a Access Database in C#