Использование ADOX

public static string GetConnectionString(
        string ADatabasePath, string AShareMode, string APassword) {
        
    StringBuilder connText = new StringBuilder();
    connText.Append("Provider=Microsoft.Jet.OLEDB.4.0;");
    connText.Append("Data Source=\"").Append(ADatabasePath).Append("\";");
    connText.Append("Mode=").Append(AShareMode).Append(";");
    if (APassword != string.Empty)
        connText.Append("Jet OLEDB:Database Password=\"").Append(APassword).Append("\";");
    connText.Append("Jet OLEDB:Engine Type=5;");
    connText.Append("Jet OLEDB:Encrypt Database=True;");
    connText.Append("User ID=\"Admin\";");
    
    return connText.ToString();
}

static ADODB.Connection g_adodbConnection; 
static ADOX.Catalog g_adoxCatalog;

public static ADOX.Catalog OpenAdoxConnection(string connectionString) { 
    try { 
        g_adodbConnection = new ADODB.ConnectionClass(); 
        g_adodbConnection.Open(connectionString, null, null, 0); 
        g_adoxCatalog = new ADOX.CatalogClass(); 
        g_adoxCatalog.ActiveConnection = g_adodbConnection; 
    } catch (Exception ex) { 
        throw new Exception("Failed to open connection", ex); 
    } 
    return g_adoxCatalog; 
}

public static void CloseAdoxConnection() { 
    try { 
        if (g_adodbConnection != null) { 
            g_adoxCatalog = null; 
            g_adodbConnection.Close(); 
            g_adodbConnection = null; 
        } 
    } 
    catch { //suppress exceptions 
    } 
}

foreach (ADOX.Table adoxTable in adoxCat.Tables) {
    string tableName = adoxTable.Name;
    if (adoxTable.Type == "LINK") {  // Это внешняя таблица
        //...
    } else
    if (adoxTable.Type == "TABLE") {  // Это обычная таблица Access
        // Перебор полей таблицы
        foreach (ADOX.Column adoxCol in adoxTable.Columns) {
            string colName = adoxCol.Name;
            //...
        }
    }
} //foreach adoxTable

SELECT MSysObjects.Name FROM MSysObjects
WHERE (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1))
ORDER BY MSysObjects.Name

OleDbConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, 
    new object[] {null, null, null, "TABLE"});

// Создаем объект-таблицу
ADOX.Table adoxTable = new ADOX.TableClass();
adoxTable.ParentCatalog = adoxCat;
adoxTable.Name = "Table1";

// Создаем поля и наполняем коллекцию Columns
// 1. Простой способ: просто указываем имя, тип и размер
adoxTable.Columns.Append("Column1", ADOX.DataTypeEnum.adInteger, 0);    // Column1 Long
adoxTable.Columns.Append("Column2", ADOX.DataTypeEnum.adVarWChar, 50);  // Column2 Text(50)

// 2. Добавление через создание объекта Column
ADOX.Column adoxColumn3 = new ADOX.ColumnClass();
adoxColumn3.ParentCatalog = adoxCat;
adoxColumn3.Name = "Column3";
adoxColumn3.Type = ADOX.DataTypeEnum.adInteger;
adoxTable.Columns.Append(adoxColumn3, ADOX.DataTypeEnum.adInteger, 0);

// 3. Добавление поля типа AutoIncrement
ADOX.Column adoxColumn4 = new ADOX.ColumnClass();
adoxColumn4.ParentCatalog = adoxCat;
adoxColumn4.Name = "Column4";
adoxColumn4.Type = ADOX.DataTypeEnum.adInteger;
adoxColumn4.Properties["AutoIncrement"].Value = true;
adoxTable.Columns.Append(adoxColumn4, ADOX.DataTypeEnum.adInteger, 0);

// Вносим изменения в базу
adoxCat.Tables.Append(adoxTable);

public static void CreateLinkedTable(
        ADOX.Catalog adoxCat,
        string ATableName, string ARemoteTableName, string ADatabasePath,
        string AProviderString)
{
    ADOX.Table adoxTable = new ADOX.TableClass();
    adoxTable.ParentCatalog = adoxCat;
    adoxTable.Name = ATableName;
    adoxTable.Properties["Jet OLEDB:Link Datasource"].Value = ADatabasePath;
    adoxTable.Properties["Jet OLEDB:Remote Table Name"].Value = ARemoteTableName;
    adoxTable.Properties["Jet OLEDB:Create Link"].Value = true;
    if (AProviderString != null)
        adoxTable.Properties["Jet OLEDB:Link Provider String"].Value = AProviderString;
    adoxCat.Tables.Append(adoxTable);
}

public static void UpdateLinkedTable(
    ADOX.Catalog adoxCat,
    string ATableName, string ADatabasePath,
    string ADatabasePassword)
{
    ADOX.Table adoxTable = adoxCat.Tables[ATableName];
    if (adoxTable == null)
        throw new WarningException("Table '" + ATableName + "' not found.");
    adoxTable.Properties["Jet OLEDB:Link Datasource"].Value = ADatabasePath;
    if (ADatabasePassword != null)
        adoxTable.Properties["Jet OLEDB:Link Provider String"].Value = "MS Access;PWD=" + ADatabasePassword + ";";
}

adoxCat.Tables.Delete("Table1");

ADOX.Table adoxTable = adoxCat.Tables["Table1"];
foreach (ADOX.Index adoxIndex in adoxTable.Indexes) {
    string indexName = adoxIndex.Name;
    ...
}

foreach (ADOX.View adoxView in adoxCat.Views) { 
    string viewname = adoxView.Name;
    ADODB.Command adoCommand = (ADODB.Command) adoxView.Command;
    string cmdtext = adoCommand.CommandText();
    //...
}

foreach(ADOX.Procedure adoxProc in adoxCat.Procedures) {
    string procname = adoxProc.Name;
    ADODB.Command adoCommand = (ADODB.Command) adoxProc.Command;
    string cmdtext = adoCommand.CommandText;
    //...
}

ADODB.Command cmdobj = new ADODB.CommandClass();
cmdobj.CommandText = "SELECT * FROM Table1";
adoxCat.Views.Append("Query1", cmdobj);

ADODB.Command cmdobj2 = new ADODB.CommandClass();
cmdobj2.CommandText = "SELECT * FROM Table1 WHERE Column1 = [_Param1]";
cmdobj2.CreateParameter("_Param1",
    ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamInput, 0, null);
adoxCat.Procedures.Append("Query2", cmdobj2);

adoxCat.Views.Delete("Query1");
adoxCat.Procedures.Delete("Query2");

public static int GetCompactReclaimedSpaceAmount(string connectionString) {
    // Открытие соединения
    ADODB.Connection connobj = new ADODB.ConnectionClass();
    connobj.Open(connectionString, null, null, 0);
    // Получение значения свойства "Jet OLEDB:Compact Reclaimed Space Amount"
    int value = 0;
    try {
        value = (int) connobj.Properties["Jet OLEDB:Compact Reclaimed Space Amount"].Value;
    } finally {
        connobj.Close();
    }
    return value;
}

public static void CompactDatabase(string ADatabasePath, string ADatabasePassword) {
    string TempFileName = Path.GetTempFileName();
    if (File.Exists(TempFileName))
        File.Delete(TempFileName);  // Удаляем файл нулевой длины, созданный Path.GetTempFileName() 
    try { 
        // Сжатие из файла ADatabasePath в файл TempFileName
        CompactDatabaseJro(
            GetCompactConnectionString(ADatabasePath, ADatabasePassword),
            GetCompactConnectionString(TempFileName, ADatabasePassword)); 
        File.Copy(TempFileName, ADatabasePath, true); 
    } finally { 
        // Удаляем временный файл
        if (File.Exists(TempFileName))
            File.Delete(TempFileName); 
    }        
}

private static string GetCompactConnectionString(string databasePath, string password) { 
    StringBuilder connText = new StringBuilder(); 
    connText.Append("Provider=Microsoft.Jet.OLEDB.4.0;"); 
    connText.Append("Data Source=\"").Append(databasePath).Append("\";"); 
    if (Common.g_Password != string.Empty)
        connText.Append("Jet OLEDB:Database Password=\"").Append(password).Append("\";");
    connText.Append("Jet OLEDB:Engine Type=5;"); 
    connText.Append("Jet OLEDB:Encrypt Database=True;"); 
    return connText.ToString(); 
}

private static void CompactDatabaseJro(string SrcConnectionString, string DestConnectionString) {
    Type typeJROJetEngine = Type.GetTypeFromProgID("JRO.JetEngine");
    object jro = Activator.CreateInstance(typeJROJetEngine);
    object[] parameter = new object[2];
    parameter[0] = SrcConnectionString;
    parameter[1] = DestConnectionString;
    typeJROJetEngine.InvokeMember("CompactDatabase", BindingFlags.InvokeMethod, null, jro, parameter);
    jro = null;
}