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); }