C / C++ / MFC

#import "c:\Program Files\Common Files\System\ADO\msadox.dll"  rename ("EOF", "adoxEOF")

HRESULT hr = S_OK;

// Define ADOX object pointers.
// Initialize pointers on define.
// These are in the ADOX::  namespace.
ADOX::_CatalogPtr m_pCatalog = NULL;
ADOX::_TablePtr   m_pTable   = NULL;

try
{
    TESTHR(hr = m_pCatalog.CreateInstance(__uuidof(ADOX::Catalog)));

    char * pChar = new char[400];
    memset(pChar, 0, 400);
    sprintf(pChar, "Provider=Microsoft.JET.OLEDB.4.0;data source=%s;", (char*)DatabasePath);

    //Open the catalog
    m_pCatalog->Create(pChar);
    delete [] pChar;

    TESTHR(hr = m_pTable.CreateInstance(__uuidof(ADOX::Table)));
    m_pTable->PutName("FileDatabase");
    m_pTable->Columns->Append("FileName",ADOX::adVarWChar, 255);
    m_pTable->Columns->Append("FilePath",ADOX::adVarWChar,255);
    m_pTable->Columns->Append("FileLength",ADOX::adInteger,0);
    m_pTable->Columns->Append("TimesDownloaded",ADOX::adInteger,0);
    m_pTable->Columns->Append("LastModified",ADOX::adInteger,0);
    m_pTable->Columns->Append("Frames",ADOX::adInteger,0);
    m_pTable->Columns->Append("Seconds",ADOX::adInteger,0);
    m_pTable->Columns->Append("Width",ADOX::adInteger,0);
    m_pTable->Columns->Append("Height",ADOX::adInteger,0);
    m_pCatalog->Tables->Append(
        _variant_t((IDispatch *)m_pTable));

    m_pCatalog->Tables->Refresh();
}

catch(_com_error &e)
{
    // Notify the user of errors if any.
    _bstr_t bstrSource(e.Source());
    _bstr_t bstrDescription(e.Description());

    MessageBox(NULL, bstrDescription, bstrSource, 0);

    return E_FAIL;
}

catch (...)
{
    MessageBox(NULL, "General Error Creating Database", "Error", 0);
    return E_FAIL;
}

return S_OK;

m_Connection.CreateInstance(__uuidof(Connection));

CComBSTR conStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";
conStr.Append(DatabasePath);

bstr_t con(conStr);

HRESULT hr = (m_Connection->Open(con, "", "", adConnectUnspecified));