C# (CSharp) Microsoft.Office.Interop.Access.Dao.DBEngine.CreateWorkspace Examples

Example #1

        private void linkTable(string fromTable, string toTable)
        {
            Microsoft.Office.Interop.Access.Dao.DBEngine  dbe = new Microsoft.Office.Interop.Access.Dao.DBEngine();
            Microsoft.Office.Interop.Access.Dao.Database  db;
            Microsoft.Office.Interop.Access.Dao.Workspace wrk;
            wrk = dbe.CreateWorkspace("", "admin", "", Microsoft.Office.Interop.Access.Dao.WorkspaceTypeEnum.dbUseJet);
            db  = wrk.OpenDatabase(textBoxPathAccess.Text);
            Microsoft.Office.Interop.Access.Dao.TableDef tdf = db.CreateTableDef();

            // MySQL ODBC 5.3 ANSI Driver
            tdf.Connect = "ODBC;Driver={" + OdbcDriver + "};Server=" + textBoxMysqlServer.Text +
                          ";Port=" + textBoxMysqlPort.Text +
                          ";Database=" + DatabaseName() + ";User="******";Password="******";Option=3;";
            tdf.Connect         = "ODBC;DSN=myDatabase";
            tdf.SourceTableName = fromTable;
            tdf.Name            = toTable;
            db.TableDefs.Append(tdf);
        }